hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-4330) Hive: AS clause with subqueries having group bys is not propogated to the outer query block
Date Tue, 21 Oct 2008 19:15:44 GMT

     [ https://issues.apache.org/jira/browse/HADOOP-4330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ashish Thusoo updated HADOOP-4330:
----------------------------------

    Fix Version/s:     (was: 0.19.1)
                   0.19.0

Fixed in 0.19.0

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


Mime
View raw message