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

Reply via email to