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

Row Count Mismatch: Partition pruning with NULL

    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
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: