Tisya Bhatia created FLINK-40378:
------------------------------------
Summary: Support GROUP BY position, ORDER BY ALL, and GROUP BY ALL
in Flink SQL
Key: FLINK-40378
URL: https://issues.apache.org/jira/browse/FLINK-40378
Project: Flink
Issue Type: Improvement
Reporter: Tisya Bhatia
Umbrella issue for the FLIP adding three validation-time SQL ergonomics
features to Flink SQL:
* GROUP BY <ordinal> - "GROUP BY 1, 2" groups by the 1st and 2nd SELECT
expressions. Redefines today's constant-grouping meaning, so it is gated behind
table.group-by-ordinal-enabled, default false.
* GROUP BY ALL - groups by every SELECT expression that is not an aggregate or
window function and that references the input. Gated behind
table.group-by-all-enabled, default false.
* ORDER BY ALL - sorts by every projected column, left to right. Gated behind
table.order-by-all-enabled, default false.
All three expand during validation into standard grouping and sorting; the
planning and execution pipeline is unchanged in streaming and batch.
Discussion thread:
https://lists.apache.org/thread/3v21hm2qv4r2bp4j29oj76qvy21c35o4
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
