AS clause with subqueries having group bys is not propogated to the outer query
block
-------------------------------------------------------------------------------------
Key: HADOOP-4330
URL: https://issues.apache.org/jira/browse/HADOOP-4330
Project: Hadoop Core
Issue Type: Bug
Components: contrib/hive
Reporter: Ashish Thusoo
Assignee: Ashish Thusoo
Fix For: 0.19.0
The query of the following form:
select a.c1, a.c2 from (select b.c1 as c1, count(b.c2) as c2 from b group by
b.c1) where a.c1 > 100
does not work as the c1 and c2 aliases are not recognized by the outer query
block.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
