更新时间:2026-11-06 GMT+08:00
分享

FlinkSQL Lookup Join支持PROCTIME()语法

使用场景

Flink Lookup Join语法中要求FOR SYSTEM_TIME AS OF包含proc_time字段,例如FOR SYSTEM_TIME AS OF o.proc_time。现在可以使用PROCTIME()代替表中的proc_time字段,直接使用FOR SYSTEM_TIME AS OF PROCTIME(),表中不需要再定义proc_time字段。子查询也适用。

使用方法

配置Flink作业时,Lookup Join可以直接使用PROCTIME()来代替表中proc_time字段。

SQL示例

CREATE TABLE kafkasource(
  order_id STRING,
  price DECIMAL(32, 2),
  currency STRING
) WITH (
  'connector' = 'kafka',
  'topic' = 'test_source',
  'properties.bootstrap.servers' = 'Kafka的Broker实例业务IP:Kafka端口号',
  'properties.group.id' = 'testGroup',
  'scan.startup.mode' = 'latest-offset',
  'format' = 'csv'
);

CREATE CATALOG lf_paimon_catalog WITH (   'type' = 'paimon',   'metastore' = 'lakeformation' );
CREATE TABLE lf_paimon_catalog.paimon_db.paimon_table (id STRING, name STRING, country STRING);

CREATE TABLE print (
  order_id STRING,
  price DECIMAL(32, 2),
  name STRING,
  country STRING
) WITH ('connector' = 'print');
insert into
  print
SELECT
  o.order_id,
  o.price,
  c.name,
  c.country
FROM
  kafkasource as o
  JOIN lf_paimon_catalog.paimon_db.paimon_table FOR SYSTEM_TIME AS OF PROCTIME() AS c ON o.order_id = c.id;

相关文档