[IMPALA-1535] Row Count Mismatch: Partition pruning with NULL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Impala 2.1.1
• Labels: correctness query_generator
• Assignee: Dimitris Tsirogiannis
• Reporter: Taras Bobrovytsky
• Created: 25/Nov/14 19:13
• Updated: 14/May/15 21:47
• Resolved: 02/Dec/14 05:31

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