回复：Compound Time interval in SQL queries

700:INTERVAL HOUR TO MINUTE). While blink planner's approach is just the opposite. (simplify expression first, and then transform window). so, you could try blink planner. thanks, godfrey -- 发件人：Arujit Pradhan 发送

回复：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

回复：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 ---