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

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: vectorization-branch, 0.13.0
    • Component/s: None
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: