Igor Guzenko created DRILL-7365:
-----------------------------------
Summary: 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
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.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
