[ https://issues.apache.org/jira/browse/HIVE-28012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhihua Deng updated HIVE-28012: ------------------------------- Description: Steps to repro: {code:java} --! qt:dataset:src --! qt:dataset:part set hive.stats.autogather=true; set hive.stats.column.autogather=true; set metastore.metadata.transformer.class=org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer; set hive.metastore.client.capabilities=HIVEFULLACIDWRITE,HIVEFULLACIDREAD; set hive.create.as.external.legacy=true; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; CREATE TABLE rename_partition_table0 (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS ORC; INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '1') SELECT * FROM src where rand(1) < 0.5; ALTER TABLE rename_partition_table0 ADD COLUMNS (new_col INT); INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '2') SELECT src.*, 1 FROM src; {code} Set hive.metastore.client.cache.v2.enabled=false can act as a workaround. was: Steps to repro: {code:java} --! qt:dataset:src --! qt:dataset:part set hive.stats.autogather=true; set hive.stats.column.autogather=true; set metastore.metadata.transformer.class=org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer; set hive.metastore.client.capabilities=HIVEFULLACIDWRITE,HIVEFULLACIDREAD; set hive.create.as.external.legacy=true; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; CREATE TABLE rename_partition_table0 (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS ORC; INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '1') SELECT * FROM src where rand(1) < 0.5; ALTER TABLE rename_partition_table0 ADD COLUMNS (new_col INT); INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '2') SELECT src.*, 1 FROM src; {code} > Invalid reference to the newly added column > ------------------------------------------- > > Key: HIVE-28012 > URL: https://issues.apache.org/jira/browse/HIVE-28012 > Project: Hive > Issue Type: Bug > Reporter: Zhihua Deng > Priority: Major > > Steps to repro: > {code:java} > --! qt:dataset:src > --! qt:dataset:part > set hive.stats.autogather=true; > set hive.stats.column.autogather=true; > set > metastore.metadata.transformer.class=org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer; > set hive.metastore.client.capabilities=HIVEFULLACIDWRITE,HIVEFULLACIDREAD; > set hive.create.as.external.legacy=true; > set hive.support.concurrency=true; > set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; > CREATE TABLE rename_partition_table0 (key STRING, value STRING) PARTITIONED > BY (part STRING) STORED AS ORC; > INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '1') SELECT > * FROM src where rand(1) < 0.5; > ALTER TABLE rename_partition_table0 ADD COLUMNS (new_col INT); > INSERT OVERWRITE TABLE rename_partition_table0 PARTITION (part = '2') SELECT > src.*, 1 FROM src; > {code} > Set hive.metastore.client.cache.v2.enabled=false can act as a workaround. -- This message was sent by Atlassian Jira (v8.20.10#820010)