[ https://issues.apache.org/jira/browse/SPARK-32821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon updated SPARK-32821: --------------------------------- Description: 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} was: current only support dsl style as below: 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() but not support group by with window in sql style as below: "select ts_field,count(\*) as cnt over window(ts_field, '1 minute', '1 minute') with watermark 1 minute from tableX group by ts_field" > 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