[
https://issues.apache.org/jira/browse/HIVE-695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14125293#comment-14125293
]
Lars Francke commented on HIVE-695:
-----------------------------------
I just checked and it's still an issue in Hive 0.12
> sort by does not support columns along with table alias when there is a group
> by
> --------------------------------------------------------------------------------
>
> Key: HIVE-695
> URL: https://issues.apache.org/jira/browse/HIVE-695
> Project: Hive
> Issue Type: Bug
> Reporter: Raghotham Murthy
> Priority: Minor
>
> The following query works:
> select a.userid from pageviews a where a.ds = '2009-07-21' sort by a.userid;
> However, the query below results in an error:
> select a.userid, count(1) from pageviews a where a.ds = '2009-07-21' group by
> a.userid sort by a.userid;
> FAILED: Error in semantic analysis: line 1:109 Invalid Table Alias or Column
> Reference a
> We should either not allow sort by after a group by or allow sort by to have
> column aliases always.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
