Gustavo de Morais created FLINK-39345:
-----------------------------------------
Summary: Support SELECT * EXCLUDE(columns) syntax in Flink SQL
Key: FLINK-39345
URL: https://issues.apache.org/jira/browse/FLINK-39345
Project: Flink
Issue Type: New Feature
Components: Table SQL / API
Reporter: Gustavo de Morais
*Current status: blocked on Calcite upgrade to 1.42*
Add support for column exclusion in SELECT statements:
{code:java}
SELECT * EXCLUDE(not_this_col) FROM a_really_wide_table;{code}
This is widely supported by Snowflake/DuckDB and is useful
for analytics use cases with wide tables.
Upstream status: Calcite added this in
https://issues.apache.org/jira/browse/CALCITE-7310 (merged Dec
2025), but it's not yet in a released version. The feature is gated behind a
parser
config flag (includeStarExclude).
Plan: Wait for a Calcite release that includes CALCITE-7310, then
upgrade and enable the flag. We could pull in the changes
earlier as we have done for other changes, but the preferred path should be
wait for the Calcite upgrade to 1.42 which will include this change.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
