[jira] [Comment Edited] (SPARK-51728) Add support for SELECT * EXCEPT

["German Schiavon Matteo (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-51728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17941301#comment-17941301 ] 

German Schiavon Matteo edited comment on SPARK-51728 at 4/6/25 5:04 AM:
------------------------------------------------------------------------

You can assign the ticket to me, I'll have the PR ready soon


was (Author: gschiavon):
You can assign the ticket for me, I'll have the PR ready soon

> Add support for SELECT * EXCEPT
> -------------------------------
>
>                 Key: SPARK-51728
>                 URL: https://issues.apache.org/jira/browse/SPARK-51728
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: German Schiavon Matteo
>            Priority: Minor
>
> This change introduces support for the SELECT * EXCEPT(col1, col2, ...) syntax, which allows users to project all columns from a dataset except for a specified subset. This pattern is especially useful in wide tables where explicitly listing all desired columns would be verbose and error-prone.
> The syntax is already widely adopted in other SQL engines like BigQuery (docs), and adding support in Spark SQL helps improve compatibility, reduce boilerplate, and improve developer ergonomics when working with large schemas.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org