You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (Updated) (JIRA)" <ji...@apache.org> on 2012/01/13 09:59:40 UTC

[jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.

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

Navis updated HIVE-2709:
------------------------

    Attachment: HIVE-2709.1.patch.txt

Hive does not search column properly if row resolver of previous operator is expressional (rs or gby). If some equivalent logic is added, this issue could be resolved. 

Attached patch is just a simple scratch.
                
> Semantic Analysis failed for GroupBy query with aliase.
> -------------------------------------------------------
>
>                 Key: HIVE-2709
>                 URL: https://issues.apache.org/jira/browse/HIVE-2709
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 0.8.0
>         Environment: SuSE11 SP1
>            Reporter: rohithsharma
>            Priority: Minor
>         Attachments: HIVE-2709.1.patch.txt
>
>
> In the SQL ,
> "select empno from test t group by t.empno"
> type of query work fine where as in hive ,below exception
> "org.apache.hadoop.hive.ql.parse.SemanticException: line 1:7 Expression Not In Group By Key ename".
> For the above, column_name with aliase work fine i.e
> "select t.empno from test t group by t.empno" is work fine.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira