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

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

Hello Jerry, Could you please describe your use-case in details. I've tried following steps and Drill reads data for new column just fine. 1) Create table create table hive_bucketed(emp_id int, first_name string) clustered by (emp_id) into 4 buckets stored as orc tblproperties

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

Hi, We are using Drill v1.16.0 to query transactional (ACID) Hive bucketed ORC table, everything is okay but when querying the columns added by HiveQL “alert table … add columns …”, Drill always returns the query result as NULL for such columns, HiveQL can query with expected results, can