Hi Weike, according to the linked documentation, the operations are ready but as you have mentioned only for SQL batch mode, which is not surprising as they don't have a well-behaved semantics on streams. See also Calcites explanations [1].
Could you maybe outline your use case and what you'd expect these operations to be? Would you like to combine them with windows? I'm CCing Jark, as he knows SQL much better than me. [1] https://calcite.apache.org/docs/stream.html#grouping-sets On Mon, Mar 9, 2020 at 8:27 AM DONG, Weike <kyled...@connect.hku.hk> wrote: > Hi, > > From the Flink 1.10 official document ( > https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/table/sql/queries.html), > we could see that GROUPING SETS is only supported in Batch mode. > > [image: image.png] > > However, we also found that in > https://issues.apache.org/jira/browse/FLINK-12192, stream query using > GROUPING SETS and CUBE is already a fixed issues in 1.9. > > Here I would like to know if SQL support for GROUPING SETS, ROLLUP, CUBE > is ready for use or not, and whether the document needs to be updated or > not. > > Thank you > > Best regards, > Weike >
