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

[Vineet Garg (JIRA)]

Title: Message Title

Vineet Garg edited a comment 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 {code} -- 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); {code} I haven't looked at your patch yet. Hopefully above queries would be helpful  in figuring out the issues . Add Comment   This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d)