[IMPALA-1411] CREATE TABLE AS SELECT produces incorrect results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.0.1
• Labels: correctness
• Assignee: Dimitris Tsirogiannis
• Reporter: Taras Bobrovytsky
• Created: 22/Oct/14 22:02
• Updated: 14/May/15 22:54
• Resolved: 03/Nov/14 17:51

Description

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

This query returns 1 row

use functional;
SELECT int_col FROM hive_view;

This query returns 3 rows

use functional;
CREATE TABLE tmp1 AS SELECT int_col FROM hive_view;
SELECT * FROM tmp1;