hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.
Date Fri, 13 Jan 2012 08:59:40 GMT

     [ 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

        

Mime
View raw message