You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2016/07/19 23:34:20 UTC

[jira] [Created] (HIVE-14291) count(*) on a table written by hcatstorer returns incorrect result

Pengcheng Xiong created HIVE-14291:
--------------------------------------

             Summary: count(*) on a table written by hcatstorer returns incorrect result
                 Key: HIVE-14291
                 URL: https://issues.apache.org/jira/browse/HIVE-14291
             Project: Hive
          Issue Type: Sub-task
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


{code}
count(*) on a table written by hcatstorer returns wrong result. 
{code}

steps to repro the issue:
1) create hive table
{noformat}
create  table ${DEST_TABLE}(name string, age int, gpa float)
                            row format delimited
                            fields terminated by '\t'
                            stored as textfile;
{noformat}

2) load data into table using hcatstorer
{noformat}
A = LOAD '$DATA_1' USING PigStorage() AS (name:chararray, age:int, gpa:float);
B = LOAD '$DATA_2' USING PigStorage() AS (name:chararray, age:int, gpa:float);
C = UNION A, B;
STORE C INTO '$HIVE_TABLE'  USING org.apache.hive.hcatalog.pig.HCatStorer();
{noformat}




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