[jira] [Updated] (FLINK-39345) Add EXCLUDE function

["Gustavo de Morais (Jira)" <ji...@apache.org>]

     [ 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)