[ https://issues.apache.org/jira/browse/DRILL-7365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Guzenko updated DRILL-7365: -------------------------------- Description: *Prerequisities:* Enable ACID in Hive [https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions]. *Steps to reproduce:* 1) create table hive_bucketed2 (emp_id int, first_name string) PARTITIONED BY (`col_year_month` string) clustered by (emp_id) into 4 buckets stored as orc tblproperties ('transactional'='true'); 2) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values (1, 'A'),(2, 'B'); 3) alter table hive_bucketed2 add columns (age INT); 4) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values (11, '1A', 10),(12, '1B', 22); 5) select * from hive.hive_bucketed2; *Workaround* (may be a little bit {color:#de350b}risky{color}:) : 1. Connect to Hive metastore database. [https://analyticsanvil.files.wordpress.com/2016/08/hive_metastore_database_diagram.png] 2. Find SDS linked to desired PARTITIONS . Actually you need CD_ID's for such SDS. 3. Insert your column into COLUMNS_V2 with CD_ID found at previous step. was: Prerequisities: Enable ACID in Hive https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions. Steps to reproduce: 1) create table hive_bucketed2 (emp_id int, first_name string) PARTITIONED BY (`col_year_month` string) clustered by (emp_id) into 4 buckets stored as orc tblproperties ('transactional'='true'); 2) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values (1, 'A'),(2, 'B'); 3) alter table hive_bucketed2 add columns (age INT); 4) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values (11, '1A', 10),(12, '1B', 22); 5) select * from hive.hive_bucketed2; Workaround (may be a little bit risky:) : 1. Connect to Hive metastore database. https://analyticsanvil.files.wordpress.com/2016/08/hive_metastore_database_diagram.png 2. Find SDS linked to desired PARTITIONS . Actually you need CD_ID's for such SDS. 3. Insert your column into COLUMNS_V2 with CD_ID found at previous step. > Failed to read column added to existing Hive partition > ------------------------------------------------------ > > Key: DRILL-7365 > URL: https://issues.apache.org/jira/browse/DRILL-7365 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Hive > Reporter: Igor Guzenko > Priority: Major > > *Prerequisities:* > Enable ACID in Hive > [https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions]. > *Steps to reproduce:* > 1) create table hive_bucketed2 (emp_id int, first_name string) PARTITIONED BY > (`col_year_month` string) clustered by (emp_id) into 4 buckets stored as orc > tblproperties ('transactional'='true'); > 2) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values > (1, 'A'),(2, 'B'); > 3) alter table hive_bucketed2 add columns (age INT); > 4) insert into hive_bucketed2 PARTITION (col_year_month = '2019-09') values > (11, '1A', 10),(12, '1B', 22); > 5) select * from hive.hive_bucketed2; > *Workaround* (may be a little bit {color:#de350b}risky{color}:) : > 1. Connect to Hive metastore database. > [https://analyticsanvil.files.wordpress.com/2016/08/hive_metastore_database_diagram.png] > 2. Find SDS linked to desired PARTITIONS . Actually you need CD_ID's for such > SDS. > 3. Insert your column into COLUMNS_V2 with CD_ID found at previous step. -- This message was sent by Atlassian Jira (v8.3.2#803003)