[ 
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

        

Reply via email to