搜了下之前的邮件,貌似没有发现和我同样的问题。

lib 下的Jar   
flink-csv-1.11.3.jar                              
flink-table-blink_2.11-1.11.3.jar
flink-dist_2.11-1.11.3.jar                        
flink-table_2.11-1.11.3.jar
flink-jdbc_2.11-1.11.3.jar                         log4j-1.2-api-2.12.1.jar
flink-json-1.11.3.jar                              log4j-api-2.12.1.jar
flink-shaded-zookeeper-3.4.14.jar                  log4j-core-2.12.1.jar
flink-sql-connector-elasticsearch6_2.11-1.11.3.jar
log4j-slf4j-impl-2.12.1.jar
flink-sql-connector-kafka_2.11-1.11.3.jar        
mysql-connector-java-5.1.48.jar

flink bin/sql-client.sh embedded

CREATE TABLE user_behavior (
    user_id BIGINT,
    item_id BIGINT,
    category_id BIGINT,
    behavior STRING,
    ts TIMESTAMP(3),
    proctime as PROCTIME(),  -- 通过计算列产生一个处理时间列
    WATERMARK FOR ts as ts - INTERVAL '5' SECOND  --
在ts上定义watermark,ts成为事件时间列

) WITH (
    'connector' = 'kafka',  -- 使用 kafka connector
    'topic' = 'data_test',  -- kafka topic
    'startup-mode' = 'earliest-offset',  -- 从起始 offset 开始读取
    'properties.bootstrap.servers' = 'localhost:9092',  -- kafka broker 地址
    'format' = 'json'  -- 数据源格式为 json
);




--
Sent from: http://apache-flink.147419.n8.nabble.com/

回复