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
('transactional'='true');
2) insert data
insert into hive_bucketed values (1, 'A'),(2, 'B');
3) queried table with Drill and got 2 columns
select * from hive.hive_bucketed
4) add new column
alter table hive_bucketed add columns (age INT);
5) set data for new column
update hive_bucketed SET age=100;
6) queried table with Drill and got 3 columns with data as expected
select * from hive.hive_bucketed
Please, provide small use-case to reproduce your issue. Also ddl and logs
are welcome:)
Thanks,
Igor
On Tue, Sep 3, 2019 at 11:03 AM FuWH(傅万红/苏州) <[email protected]> wrote:
> 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 anyone
> help to give an adivse on how to solve this issue?
>
> Appreciated & Thanks
> Jerry
