Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1535

Row Count Mismatch: Partition pruning with NULL

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      Impala Query:

      SELECT
      (t1.year) * (t1.year) AS int_col,
      t1.tinyint_col,
      COALESCE(t1.bigint_col, t1.bigint_col, t1.int_col) AS int_col_2
      FROM alltypestiny t1
      WHERE
      (t1.year) != (NULL)
      

      Postgres Query:

      SELECT
      (t1.year) * (t1.year) AS int_col,
      t1.tinyint_col,
      COALESCE(t1.bigint_col, t1.bigint_col, t1.int_col) AS int_col_2
      FROM alltypestiny t1
      WHERE
      (t1.year) != (NULL)
      

      Number of rows returned by Impala: 8
      Number of rows returned by Postgres: 0
      DB: Functional
      File Format: Text/None
      git Hash: 09363ef

        Attachments

          Activity

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              tarasbob Taras Bobrovytsky

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment