sql ????josn?????????? ????????????

[claylin]

hi all????????????????json????????????????????(ts AS 
CAST(FROM_UNIXTIME(hiido_time) AS TIMESTAMP(3)),????????)??????????????????
create table hiido_push_sdk_mq (
datas&nbsp; &nbsp;ARRAY<ROW<`from` string,hdid string,event string,hiido_time 
bigint,ts AS CAST(FROM_UNIXTIME(hiido_time) AS TIMESTAMP(3)),WATERMARK FOR ts 
AS ts - INTERVAL '5' MINUTE&gt;&gt;
) with (
'connector' = 'kafka',
'topic' = 'hiido_pushsdk_event',
'properties.bootstrap.servers' = 
'kafkafs002-core001.yy.com:8103,kafkafs002-core002.yy.com:8103,kafkafs002-core003.yy.com:8103',
'properties.group.id' = 'push_click_sql_version_consumer',
'scan.startup.mode' = 'latest-offset',
'format.type' = 'json');




??????????
[ERROR] 2020-07-17 20:17:50,640(562284338) --&gt; [http-nio-8080-exec-10] 
com.yy.push.flink.sql.gateway.sql.parse.SqlCommandParser.parseBySqlParser(SqlCommandParser.java:77):
 parseBySqlParser, parse: 
com.yy.push.flink.sql.gateway.context.JobContext$1@5d5f32d1, stmt: create table 
hiido_push_sdk_mq (&nbsp; &nbsp; datas&nbsp; &nbsp;ARRAY<ROW<`from` string,hdid 
string,event string,hiido_time bigint,ts AS CAST(FROM_UNIXTIME(hiido_time) AS 
TIMESTAMP(3)),WATERMARK FOR ts AS ts - INTERVAL '5' MINUTE&gt;&gt;) with 
('connector' = 'kafka','topic' = 
'hiido_pushsdk_event','properties.bootstrap.servers' = 
'kafkafs002-core001.yy.com:8103,kafkafs002-core002.yy.com:8103,kafkafs002-core003.yy.com:8103','properties.group.id'
 = 'push_click_sql_version_consumer','scan.startup.mode' = 
'latest-offset','format.type' = 'json'), error info: SQL parse failed. 
Encountered "AS" at line 1, column 115.
Was expecting one of:
&nbsp; &nbsp; "ROW" ...
&nbsp; &nbsp; <BRACKET_QUOTED_IDENTIFIER&gt; ...
&nbsp; &nbsp; <QUOTED_IDENTIFIER&gt; ...
&nbsp; &nbsp; <BACK_QUOTED_IDENTIFIER&gt; ...
&nbsp; &nbsp; <IDENTIFIER&gt; ...
&nbsp; &nbsp; <UNICODE_QUOTED_IDENTIFIER&gt; ...
&nbsp; &nbsp; "STRING" ...
&nbsp; &nbsp; "BYTES" ...
&nbsp; &nbsp; "ARRAY" ...
&nbsp; &nbsp; "MULTISET" ...
&nbsp; &nbsp; "RAW" ...
&nbsp; &nbsp; "BOOLEAN" ...
&nbsp; &nbsp; "INTEGER" ...
&nbsp; &nbsp; "INT" ...
&nbsp; &nbsp; "TINYINT" ...
&nbsp; &nbsp; "SMALLINT" ...
&nbsp; &nbsp; "BIGINT" ...
&nbsp; &nbsp; "REAL" ...
&nbsp; &nbsp; "DOUBLE" ...
&nbsp; &nbsp; "FLOAT" ...
&nbsp; &nbsp; "BINARY" ...
&nbsp; &nbsp; "VARBINARY" ...
&nbsp; &nbsp; "DECIMAL" ...
&nbsp; &nbsp; "DEC" ...
&nbsp; &nbsp; "NUMERIC" ...
&nbsp; &nbsp; "ANY" ...
&nbsp; &nbsp; "CHARACTER" ...
&nbsp; &nbsp; "CHAR" ...
&nbsp; &nbsp; "VARCHAR" ...
&nbsp; &nbsp; "DATE" ...
&nbsp; &nbsp; "TIME" ...
&nbsp; &nbsp; "TIMESTAMP" ...