You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-dev@hadoop.apache.org by "Ashish Thusoo (JIRA)" <ji...@apache.org> on 2008/10/02 04:40:44 UTC

[jira] Updated: (HADOOP-4330) Hive: AS clause with subqueries having group bys is not propogated to the outer query block

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