[IMPALA-1550] Row Count Mismatch

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Product Backlog
• Labels: correctness query_generator
• Assignee: Dimitris Tsirogiannis
• Reporter: Taras Bobrovytsky
• Created: 26/Nov/14 00:23
• Updated: 02/Apr/15 23:37
• Resolved: 02/Apr/15 23:37

Description

Impala Query:

SELECT
COALESCE(t1.bigint_col, t1.bigint_col, t1.tinyint_col) AS int_col
FROM alltypestiny t1
WHERE
NOT EXISTS (SELECT
((680) - (803)) * (SUM(smallint_col)) AS int_col
FROM alltypestiny
WHERE
((t1.date_string_col) = (string_col)) AND ((t1.timestamp_col) = (timestamp_col)))
GROUP BY
COALESCE(t1.bigint_col, t1.bigint_col, t1.tinyint_col)

Postgres Query:

SELECT
COALESCE(t1.bigint_col, t1.bigint_col, t1.tinyint_col) AS int_col
FROM alltypestiny t1
WHERE
NOT EXISTS (SELECT
((680) - (803)) * (SUM(smallint_col)) AS int_col
FROM alltypestiny
WHERE
((t1.date_string_col) = (string_col)) AND ((t1.timestamp_col) = (timestamp_col)))
GROUP BY
COALESCE(t1.bigint_col, t1.bigint_col, t1.tinyint_col)

Number of rows returned by Impala: 2
Number of rows returned by Postgres: 0
DB: Functional
File Format: Text/None
git Hash: c295948