[jira] (HIVE-15160) Can't order by an unselected column

[Vineet Garg (JIRA)]

Title: Message Title

Vineet Garg commented on HIVE-15160   Re: Can't order by an unselected column I applied your patch locally and tried running following tests but none of them worked. Following queries have the pattern observed in tpcds queries -- order by has aggregate which is in select select sum(p_retailprice) from part order by sum(p_retailprice); -- order by has item which isn't in select select sum(p_retailprice) from part group by p_type order by p_type; -- order by isn't using alias from select select sum(p_retailprice) as ps from part order by sum(p_retailprice); I haven't looked at your patch yet. Hopefully above queries would be helpful. Add Comment   This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d)