Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12656 Turn hive.compute.query.using.stats on by default
  3. HIVE-14291

count(*) on a table written by hcatstorer returns incorrect result

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0, 2.1.0
    • 2.1.1, 2.2.0
    • None
    • None

    Description

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

      steps to repro the issue:
      1) create hive table

      create  table ${DEST_TABLE}(name string, age int, gpa float)
                                  row format delimited
                                  fields terminated by '\t'
                                  stored as textfile;
      

      2) load data into table using hcatstorer

      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();
      

      Attachments

        1. HIVE-14291.01.patch
          8 kB
          Pengcheng Xiong
        2. HIVE-14291.02.patch
          10 kB
          Pengcheng Xiong

        Activity

          People

            pxiong Pengcheng Xiong
            pxiong Pengcheng Xiong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: