FlinkSQL中如何正确配置时区?

提问者:帅平 问题分类:大数据
FlinkSQL中如何正确配置时区?
1 个回答
得治
得治
1、在表中显示指定时区
-- 创建表时指定时区为UTC
CREATE TABLE events (
  event_id STRING,
  event_time TIMESTAMP(3),
  WATERMARK FOR event_time AS event_time - INTERVAL '5' SECOND
) WITH (
  'connector' = 'kafka',
  'topics' = 'events_topic',
  'timezone' = 'UTC'  -- 显式设置时区
);
2、在flink.conf中配置时区
# flink-conf.yaml
execution.timezone: Asia/Shanghai
3、在Eev中设置时区
// Java代码中设置
StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
env.getConfig().setLocalTimeZone(ZoneId.of("Asia/Shanghai"));
发布于:3周前 (05-28) IP属地:
我来回答