[jira] Created: (HIVE-695) sort by does not support columns along with table alias when there is a group by

[Raghotham Murthy (JIRA)]

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: Hadoop 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.