[ https://issues.apache.org/jira/browse/SPARK-32821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17192138#comment-17192138 ]
Jungtaek Lim commented on SPARK-32821: -------------------------------------- Let's leave the fix version field be empty - the field will be filled when the issue is resolved with specific patch. It's a challenging work to bind all Dataset APIs with SQL statement, especially SS, given the fact Streaming SQL doesn't have a standard. > cannot group by with window in sql sentence 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: 2.1.0, 2.2.0, 2.3.0, 2.4.0 > Reporter: Johnny Bai > Priority: Major > > 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" > -- 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