cristhiank opened a new pull request, #2283: URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2283
## Summary Two ClickHouse dialect improvements: 1. **PARTITION BY after ORDER BY** — ClickHouse CREATE TABLE DDL places PARTITION BY after ORDER BY, which differs from standard SQL. The parser now accepts both orderings when using the ClickHouseDialect or GenericDialect. 2. **ARRAY JOIN support** — Adds \JoinOperator\ variants for \ARRAY JOIN\, \LEFT ARRAY JOIN\, and \INNER ARRAY JOIN\. These are ClickHouse-specific constructs for unnesting arrays inline. ## Motivation These patterns appear in production ClickHouse deployments and currently fail to parse with the ClickHouseDialect. ## Changes - \src/parser/mod.rs\: Accept PARTITION BY after ORDER BY in CREATE TABLE (ClickHouse + Generic dialect) - \src/ast/query.rs\: New \JoinOperator\ variants: \ArrayJoin\, \LeftArrayJoin\, \InnerArrayJoin\ with Display impl - \src/ast/spans.rs\: \Spanned\ impl for new \JoinOperator\ variants - \src/parser/mod.rs\: Recognize \ARRAY JOIN\, \LEFT ARRAY JOIN\, \INNER ARRAY JOIN\ in \parse_joins()\ - \ ests/sqlparser_clickhouse.rs\: Added test cases for both features -- 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]
