hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis Ryu" <navis....@nexr.com>
Subject Review Request 31335: Correlating expression cannot contain unqualified column references
Date Tue, 24 Feb 2015 01:10:58 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/31335/
-----------------------------------------------------------

Review request for hive.


Bugs: HIVE-9734
    https://issues.apache.org/jira/browse/HIVE-9734


Repository: hive-git


Description
-------

The following valid ISO-SQL constructs will not parse

Unsupported SubQuery Expression 'c1': Correlating expression cannot contain unqualified column
references

The statement will parse if the predicate is changed to where tjoin1.c1 in ( ....)

select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select c1 from tjoin1)


select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select tjoin1.c1 from tjoin1)


select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select x.c1 from tjoin1
x)


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/parse/QBSubQuery.java 1b6b33b 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java 57868b7 
  ql/src/test/queries/clientnegative/subquery_unqual_corr_expr.q 99ff9ca 
  ql/src/test/queries/clientpositive/subquery_unqual_corr_expr.q PRE-CREATION 
  ql/src/test/results/clientnegative/subquery_unqual_corr_expr.q.out f69a538 
  ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out PRE-CREATION 

Diff: https://reviews.apache.org/r/31335/diff/


Testing
-------


Thanks,

Navis Ryu


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message