siying opened a new pull request, #59960:
URL: https://github.com/apache/spark/pull/59960
### What changes were proposed in this pull request?
This PR adds Structured Streaming SQL golden tests that run with
`Trigger.AvailableNow` through `StreamingSQLQueryTestSuite`.
The positive coverage includes CTEs, ROLLUP, CUBE, GROUPING SETS, and
stream-static window aggregation. The negative coverage exercises unsupported
append-mode operations, distinct aggregation, ASOF/NEAREST BY/full outer
joins,
streaming subqueries, set operations, sorting, TABLESAMPLE, SQL windows,
OFFSET,
and `monotonically_increasing_id()`.
The negative tests follow the batch SQL-test convention of organizing inputs
by
SQL feature, with related set operations kept in one file. Both execution and
analyzer golden files are included.
### Why are the changes needed?
SPARK-60416 introduced SQL golden-test support for Structured Streaming
flows.
These tests exercise that framework with more representative SQL workloads
and
verify the validation errors for SQL features that Structured Streaming does
not
support.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
The focused Streaming SQL golden suite passed all 40 matching tests:
```
SPARK_GENERATE_GOLDEN_FILES=1 build/sbt \
'sql/testOnly org.apache.spark.sql.StreamingSQLQueryTestSuite -- -z
available-now-'
```
### Was this patch authored or co-authored using generative AI tooling?
Generated-by: OpenAI Codex (GPT-5)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
