[ https://issues.apache.org/jira/browse/SPARK-32821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17195792#comment-17195792 ]
Hyukjin Kwon commented on SPARK-32821: -------------------------------------- [~johnny bai] can you provide a self-contained reproducer BTW? It's easier to discuss and talk with reproducible examples. > cannot group by with window in sql statement for structured streaming with > watermark > ------------------------------------------------------------------------------------ > > Key: SPARK-32821 > URL: https://issues.apache.org/jira/browse/SPARK-32821 > Project: Spark > Issue Type: Improvement > Components: Structured Streaming > Affects Versions: 3.1.0 > Reporter: Johnny Bai > Priority: Major > > current only support dsl style as below: > {code} > import spark.implicits._ > val words = ... // streaming DataFrame of schema { timestamp: Timestamp, > word: String } > // Group the data by window and word and compute the count of each group > val windowedCounts = words.groupBy(window($"timestamp", "10 minutes", "5 > minutes"),$"word").count() > {code} > > but not support group by with window in sql style as below: > {code} > select ts_field,count(\*) as cnt over window(ts_field, '1 minute', '1 > minute') with watermark 1 minute from tableX group by ts_field > {code} > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org