Re: Using time window with SQL nested query

2018-03-05 Thread 杨力
Thanks. It works. I missed it while reading the document. Timo Walther 于 2018年3月5日周一 下午9:20写道: > Hi Bill, > > you can use HOP_ROWTIME()/HOP_PROCTIME() to propagate the time attribute > to the outer query. See also [1] for an example. > > Regards, > Timo > > [1] > https://ci.apache.org/projects/f

Re: Using time window with SQL nested query

2018-03-05 Thread Timo Walther
Hi Bill, you can use HOP_ROWTIME()/HOP_PROCTIME() to propagate the time attribute to the outer query. See also [1] for an example. Regards, Timo [1] https://ci.apache.org/projects/flink/flink-docs-release-1.4/dev/table/sql.html#selecting-group-window-start-and-end-timestamps Am 3/5/18 um

Using time window with SQL nested query

2018-03-05 Thread 杨力
I tried to use write a nested query with HOP window in a streaming environment. Table `source` consists of 3 column, a, b, and timestamp. SELECT a FROM (SELECT a, COUNT(*) FROM source GROUP BY HOP(timestamp, ..., ...), a, b) GROUP BY HOP(timestamp, ..., ...), a HAVING ... And flink throws an exc