You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-zh@flink.apache.org by allanqinjy <al...@163.com> on 2020/04/10 08:43:33 UTC

dayofweek异常

hi，
   在flink中使用hql函数的时候 dayofweek  报错，编译都没有通过。我的使用方式 
用yyyy-MM-dd也是一样的错误。哪位大神遇到过！
DAYOFWEEK(to_date(from_unixtime (unix_timestamp(cast(dt as string),'yyyyMMdd'),'yyyy-MM-dd HH:mm:ss')))


，Cannot apply 'EXTRACT' to arguments of type 'EXTRACT(<INTERVAL DOW> FROM <VARCHAR(2147483647)>)'. Supported form(s): 'EXTRACT(<DATETIME_INTERVAL> FROM <DATETIME_INTERVAL>)'
10-04-2020 16:26:14 CST user_visit_terminal_prefer_7d INFO - 'EXTRACT(<DATETIME_INTERVAL> FROM <DATETIME>)'
10-04-2020 16:26:14 CST user_visit_terminal_prefer_7d INFO - 	at org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:130)
10-04-2020 16:26:14 CST user_visit_terminal_prefer_7d INFO - 	at org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:105)