Hi,
With ORCFiles data inserted into the first table only. Hive 0.13 test:
create table orc1
stored as orc
tblproperties ("orc.compress"="ZLIB")
as
select rn
from
(
select cast(1 as int) as rn from dual
union all
select cast(100 as int) as rn from dual
union all
select cast(10000 as int) as rn from dual
) t;
create table orc_rn1 (rn int);
create table orc_rn2 (rn int);
create table orc_rn3 (rn int);
from orc1 a
insert overwrite table orc_rn1 select a.* where a.rn < 100
insert overwrite table orc_rn2 select a.* where a.rn >= 100 and a.rn < 1000
insert overwrite table orc_rn3 select a.* where a.rn >= 1000;
select * from orc_rn1
union all
select * from orc_rn2
union all
select * from orc_rn3;
----
Result (only one row):
1
If I change orc1 to SequenceFile everything works fine (the last query
returns 3 rows). Can please someone check this? Is it a known issue?
Thanks,
Dmitry Tolpeko