----------------------------------------------------------- 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