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

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              jnp Jitendra Nath Pandey Assign to me
              Reporter:
              anthony.murphy Tony Murphy

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment