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. HIVE-4714.1.patch
          5 kB
          Jitendra Nath Pandey
        2. sum_data.zip
          4.31 MB
          Tony Murphy

        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: