[
https://issues.apache.org/jira/browse/FLINK-39345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gustavo de Morais updated FLINK-39345:
--------------------------------------
Summary: Add EXCLUDE function (was: Support SELECT * EXCLUDE(columns)
syntax in Flink SQL )
> Add EXCLUDE function
> --------------------
>
> Key: FLINK-39345
> URL: https://issues.apache.org/jira/browse/FLINK-39345
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Gustavo de Morais
> Priority: Major
>
> *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)
