[IMPALA-1429] Failed to resolve column ref in uncorrelated subquery

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Impala 2.1
• Assignee: casey
• Reporter: casey
• Created: 27/Oct/14 22:17
• Updated: 14/Nov/14 22:40
• Resolved: 14/Nov/14 22:40

Description

The query below is a valid uncorrelated subquery but Impala says a column is ambiguous

Query: select 1 FROM alltypestiny WHERE int_col IN (
SELECT 1 AS int_col FROM alltypesagg)
ERROR: AnalysisException: unqualified column reference 'int_col' is ambiguous

Postgresql

functional=# select 1 FROM alltypestiny WHERE int_col IN (
functional(# SELECT 1 AS int_col FROM alltypesagg) LIMIT 1;
 ?column? 
----------
        1
(1 row)