You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2014/10/29 21:16:33 UTC

[jira] [Created] (HIVE-8654) CBO: parquet_ctas test returns incorrect results

Sergey Shelukhin created HIVE-8654:
--------------------------------------

             Summary: CBO: parquet_ctas test returns incorrect results
                 Key: HIVE-8654
                 URL: https://issues.apache.org/jira/browse/HIVE-8654
             Project: Hive
          Issue Type: Sub-task
            Reporter: Sergey Shelukhin
            Assignee: Sergey Shelukhin


I am investigating right now. 
The issue is specific to Parquet:

{noformat}
set hive.cbo.enable=true;
drop table staging;
drop table parquet_ctas;

create table staging (key int, value string) stored as textfile;
insert into table staging select * from src order by key limit 10;
select * from staging;

create table parquet_ctas stored as parquet as select * from staging;
select * from parquet_ctas;
create table orc_ctas stored as orc as select * from staging;
select * from orc_ctas;
create table txt_ctas stored as textfile as select * from staging;
select * from txt_ctas;
{noformat}

The parquet query returns all NULLs with CBO on.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)