[
https://issues.apache.org/jira/browse/HADOOP-4330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashish Thusoo updated HADOOP-4330:
----------------------------------
Summary: Hive: AS clause with subqueries having group bys is not propogated
to the outer query block (was: AS clause with subqueries having group bys is
not propogated to the outer query block)
> Hive: 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.
