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] Created: (HADOOP-4330) AS clause with subqueries having
group bys is not propogated to the outer query block
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.
[jira] Updated: (HADOOP-4330) Hive: AS clause with subqueries
having group bys is not propogated to the outer query block
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ 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.0)
0.19.1
Fixed in 0.19.1
> 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.1
>
>
> 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.
[jira] Updated: (HADOOP-4330) Hive: AS clause with subqueries
having group bys is not propogated to the outer query block
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HADOOP-4330) Hive: AS clause with subqueries
having group bys is not propogated to the outer query block
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (HADOOP-4330) Hive: AS clause with subqueries
having group bys is not propogated to the outer query block
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-4330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo resolved HADOOP-4330.
-----------------------------------
Resolution: Fixed
Fixed as part of JIRA-4230
> 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.