Flink Sql源表时间类型及水印字段生成

test01

2020-06-01T03:56:53.123 pt AS PROCTIME() pt
2020-06-01T11:56:50 wt AS TO_TIMESTAMP(t4) wt
2020-06-01T11:56:50 t5 AS CAST(FROM_UNIXTIME(CAST(t3 AS BIGINT)) AS TIMESTAMP) t5

源端字段级类型	源端发送数据格式	映射后的数据格式	建表语句操作(映射关系)	映射后的字段
t1[String]	Mon Jun 01 11:56:50 CST 2020	Mon Jun 01 11:56:50 CST 2020	VARCHAR	t1
t2[long]	1590983810058	1590983810058	VARCHAR	t2
t3[long]	1590983810	1590983810	VARCHAR	t3
t4[String]	2020-06-01 11:56:50	2020-06-01 11:56:50	VARCHAR	t4
		2020-06-01T03:56:53.123	pt AS PROCTIME()	pt
		2020-06-01T11:56:50	wt AS TO_TIMESTAMP(t4)	wt
		2020-06-01T11:56:50	t5 AS CAST(FROM_UNIXTIME(CAST(t3 AS BIGINT)) AS TIMESTAMP)	t5

说明:
1.源表类型最好用VARCHAR去映射,如果需要水印字段使用计算列,如wt,或者t5,除非数据本身是TIMESTAMP(3)类型的;
2.生成wt字段的t4只能是VARCHAR类型,生成t5的t3只能是10位的时间戳;

具体时间函数的使用可以参考:
https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/table/functions/systemFunctions.html#type-conversion-functions