Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4160 Vectorized Query Execution in Hive
  3. HIVE-4686

Max on float returning wrong results

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • vectorization-branch
    • vectorization-branch, 0.13.0
    • None
    • None

    Description

      Text and Orc returning: 1.4499999
      Vectorized Orc Returning: 0.1

      drop table LINEITEM_ORC;
create external table LINEITEM_ORC(L_DISCOUNT float ) 
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
            STORED AS
                INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.CommonOrcInputFormat'
                OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';

      SELECT max(l_discount)
FROM   LINEITEM_ORC

      Attachments

        1. max_data.zip
          4.31 MB
          Tony Murphy
        2. hive-4686.patch.1.txt
          50 kB
          Remus Rusanu

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue HIVE-4687 incorrect result for max aggregate over int column

          • Major - Major loss of function.
          • Resolved
          relates to

          Sub-task - The sub-task of the issue HIVE-4722 MIN on timestamp column gives incorrect result.

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              rusanu Remus Rusanu
              anthony.murphy Tony Murphy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: