[
https://issues.apache.org/jira/browse/HIVE-29786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raghav Aggarwal updated HIVE-29786:
-----------------------------------
Description:
When querying wide tables, users often want to select almost all columns while
exclusing a few like PI (personal information) columns. QueryEngines like
Snowflake, DuckDB, BigQuery support this feauture
DuckDB:
[https://duckdb.org/docs/sql/query_syntax/select.html#exclude-and-replace]
{code:java}
SELECT * EXCLUDE (col_name) {code}
Snowflake: [https://docs.snowflake.com/en/sql-reference/sql/select#parameters]
{code:java}
SELECT * EXCLUDE (col_name) {code}
BigQuery:
[https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_except]
{code:java}
SELECT * EXCEPT(col_name) {code}
> Support SELECT * EXCLUDE syntax for column omission
> ---------------------------------------------------
>
> Key: HIVE-29786
> URL: https://issues.apache.org/jira/browse/HIVE-29786
> Project: Hive
> Issue Type: Improvement
> Reporter: Raghav Aggarwal
> Assignee: Raghav Aggarwal
> Priority: Major
>
> When querying wide tables, users often want to select almost all columns
> while exclusing a few like PI (personal information) columns. QueryEngines
> like Snowflake, DuckDB, BigQuery support this feauture
>
> DuckDB:
> [https://duckdb.org/docs/sql/query_syntax/select.html#exclude-and-replace]
> {code:java}
> SELECT * EXCLUDE (col_name) {code}
> Snowflake: [https://docs.snowflake.com/en/sql-reference/sql/select#parameters]
> {code:java}
> SELECT * EXCLUDE (col_name) {code}
>
> BigQuery:
> [https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_except]
> {code:java}
> SELECT * EXCEPT(col_name) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
