回复:Compound Time interval in SQL queries

2019-11-21 Thread 贺小令(晓令)
时间:2019年11月21日(星期四) 17:31 收件人:贺小令(晓令) 主 题:Re: Compound Time interval in SQL queries Hi, godfrey, We are using flink-1.6.2. But when working with flink-1.9 I am still getting this error. Exception in thread "main" org.apache.flink.client.program.ProgramInvocationException: org.apac

回复:Compound Time interval in SQL queries

2019-11-21 Thread 贺小令(晓令)
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

Re: Compound Time interval in SQL queries

2019-11-21 Thread Arujit Pradhan
LE ( rowtime, INTERVAL '7' HOUR + INTERVAL '30' MINUTE) > > thanks, > godfrey > > -- > 发件人:Arujit Pradhan > 发送时间:2019年11月21日(星期四) 16:23 > 收件人:user > 主 题:Compound Time interval in SQL quer

回复:Compound Time interval in SQL queries

2019-11-21 Thread 贺小令(晓令)
'30' MINUTE) thanks, godfrey -- 发件人:Arujit Pradhan 发送时间:2019年11月21日(星期四) 16:23 收件人:user 主 题:Compound Time interval in SQL queries Hi all, Is there a way to define a compound time interval(that can consist of both HOUR and MINUT

Compound Time interval in SQL queries

2019-11-21 Thread Arujit Pradhan
Hi all, Is there a way to define a compound time interval(that can consist of both HOUR and MINUTE) in windows in a Flink SQL query. For example, we want to do something like this: SELECT count(1) AS event_count , TUMBLE_END(rowtime, INTERVAL '7' HOUR AND '30' MINUTE) AS window_timestamp FROM `da