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

Vectorized Sum of scalar subtract column returns negative result when positive exected

    XMLWordPrintableJSON

Details

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

    Description

      Actual: -5701157.669591231
      Expected: 5701157.663489044

      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 Sum(1 - l_discount) FROM   Lineitem_orc

      Attachments

        1. sum_data.zip
          4.31 MB
          Tony Murphy
        2. HIVE-4714.1.patch
          5 kB
          Jitendra Nath Pandey

        Activity

          People

            jnp Jitendra Nath Pandey
            anthony.murphy Tony Murphy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: