trinodb/trino

Restrict drop column operations for hive tables

オープン

#20,807 opened on 2024/02/22

 (4 件のコメント) (0 件のリアクション) (0 人の担当者)Java (2,678 件のフォーク)batch import
good first issuehive

Repository metrics

Stars
 (9,113 個のスター)
PR merge metrics
 (PR metrics pending)

説明

As per the Hive docs - https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable/Partition/Column

REPLACE COLUMNS removes all existing columns and adds the new set of columns. This can be done only for tables with a native SerDe (DynamicSerDe, MetadataTypedColumnsetSerDe, LazySimpleSerDe and ColumnarSerDe). Refer to Hive SerDe for more information. REPLACE COLUMNS can also be used to drop columns. For example, "ALTER TABLE test_change REPLACE COLUMNS (a int, b int);" will remove column 'c' from test_change's schema.

But we try to run replace columns operation for all the file formats which provides inconsistent behavior both from Trino's hive connector and querying hive directly.

コントリビューターガイド