hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5874) SubQuery: better error handling when SQ and Outer Query has the same table alias
Date Fri, 22 Nov 2013 22:06:35 GMT
Harish Butani created HIVE-5874:
-----------------------------------

             Summary: SubQuery: better error handling when SQ and Outer Query has the same
table alias
                 Key: HIVE-5874
                 URL: https://issues.apache.org/jira/browse/HIVE-5874
             Project: Hive
          Issue Type: Bug
            Reporter: Harish Butani
            Priority: Minor


The following query
{noformat}
select * from src where key in (select key from src where src.key > '1')
{noformat}

Gives the following message:
{noformat}
emanticException [Error 10249]: Line 1:58 Unsupported SubQuery Expression ''1'': SubQuery
expression refers to Outer query expressions only.
{noformat}

Whereas the user is attempting to express an uncorrelated Subquery.
The ambiguity is because we attempt to resolve references against  the Outer Query first.
This is an implementation detail, see the Sub Query spec for details. For now it is better
to disallow such SubQueries.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message