Group by and order by of the same columns fails semantic analysis
-----------------------------------------------------------------
Key: HIVE-2348
URL: https://issues.apache.org/jira/browse/HIVE-2348
Project: Hive
Issue Type: Bug
Affects Versions: 0.7.1
Reporter: Edward Capriolo
select offer, level_id, sum_cl_score as sumcl_floor
FROM xxx
GROUP BY offer, level_id, sumcl_floor
ORDER BY offer, level_id, sumcl_floor limit 1000000;
FAILED: Error in semantic analysis: Invalid Table Alias or Column Reference
sumcl_floor
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
