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)