Any update on this bug. Currently we are facing the same issue in hive.
Issue overview Say we have a table named T1 stored as orc. Select * fom t1 would yeild the following result. Key | Value | 1 | |<-- Empty
Now, we create table T2 like T1 Create TABLE T2 like T1;
Unload data from T1 to T2 Insert into T2 select * from T1;
If we query T2 i see all empty values converted to NULL's Key | Value 1 | NULL
Any update on this bug. Currently we are facing the same issue in hive.
Issue overview
Say we have a table named T1 stored as orc. Select * fom t1 would yeild the following result.
Key | Value |
1 | |<-- Empty
Now, we create table T2 like T1
Create TABLE T2 like T1;
Unload data from T1 to T2
Insert into T2 select * from T1;
If we query T2 i see all empty values converted to NULL's
Key | Value
1 | NULL