回复：Compound Time interval in SQL queries

hi arujit, blink planner with flink-1.9 supports this query. the reason is both planners do not support complex expressions like INTERVAL '7' HOUR + INTERVAL '30' MINUTE when transforming window to LogicalWindowAggregate node now. why blink planner supports this query? the optimization orde

回复：Compound Time interval in SQL queries

hi arujit, Which Flink version are you using? thanks, godfrey -- 发件人：Arujit Pradhan 发送时间：2019年11月21日(星期四) 17:21 收件人：贺小令(晓令) ; user 主　题：Re: Compound Time interval in SQL queries Hi, godfrey, Thanks for your reply. But now I am

回复：Compound Time interval in SQL queries

please try this approach: interval + interval like this: SELECT count(1) AS event_count , TUMBLE_END(rowtime, INTERVAL '7' HOUR + INTERVAL '30' MINUTE) AS window_timestamp FROM `data_stream` GROUP BY TUMBLE ( rowtime, INTERVAL '7' HOUR + INTERVAL '30' MINUTE) thanks, godfrey ---