[IMPALA-1412] CREATE VIEW AS SELECT produces incorrect results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.1
• Labels: correctness
• Assignee: Dimitris Tsirogiannis
• Reporter: Taras Bobrovytsky
• Created: 22/Oct/14 23:06
• Updated: 14/May/15 21:50
• Resolved: 05/Nov/14 00:52

Description

The following queries should return identical results, but this is not the case.

This query returns 11000 rows:

use functional;
SELECT
tinyint_col,
tinyint_col AS tinyint_col_2,
bigint_col
FROM alltypesagg;

This query returns 9000 rows:

use functional;
create VIEW tmp_view AS SELECT
tinyint_col,
tinyint_col AS tinyint_col_2,
bigint_col
FROM alltypesagg;
SELECT * FROM tmp_view;