Re: Drill query result with NULL for new added column in transactional (ACID) Hive bucketed ORC table

2019-09-03 Thread WanHong Fu
Hi Igor, Thanks for your reply. For you case Drill works fine. But if the table created with Partition, will hit the issue. My case is as below: 1) *create* *table *hive_bucketed2 (emp_id *int*, first_name *string*) PARTITIONED *BY* (`col_year_month` *string*) clustered *by* (emp_id) *into* 4

Re: Drill query result with NULL for new added column in transactional (ACID) Hive bucketed ORC table

2019-09-04 Thread WanHong Fu
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; WanHong Fu 于2019年9月4日周三 上午9:52写

Re: Drill query result with NULL for new added column in transactional (ACID) Hive bucketed ORC table

2019-09-06 Thread WanHong Fu
Hi Igor, Thanks for reply. Your workaround need to touch Hive metastore but it is impossible for us so far. May I know is there a plan to fix this issue from Drill side as we are eager to get it work. Thanks Jerry Igor Guzenko 于2019年9月4日周三 下午4:45写道: > Hello Jerry, > > Thank you very much for