Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4810 DECIMAL datatype changes for Impala 2.9
  3. IMPALA-4370

DECIMAL divide result type (Impala TPC-DS query 11 result lost one row)

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.8.0
    • Impala 2.9.0
    • Frontend

    Description

      The result of TPC-DS query 11 in Impala is wrong. It lost a record :
      "AAAAAAAAOPDLAAAA | Ann | Pence N"

      I'm using tpcds 1g validation dataset generated by command:
      "./dsdgen -sc 1 -terminate N -validate Y"
      with tpc-ds-2.3.0

      Attachments are the query string, result of Impala and tpc-ds answer set.

      Note: I have also run this query in PostgreSQL and it gives the same result as tpc-ds result set.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            dhecht Daniel Hecht
            yhluo_impala_39a4 Yuanhao Luo
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment