[HIVE-2348] Group by and order by of the same columns fails semantic analysis

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7.1
• Assignee: Unassigned
• Reporter: Edward Capriolo
• Created: 04/Aug/11 17:47
• Updated: 06/Feb/13 09:23

Description

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

Issue Links

• is related to: HIVE-3991 junit failure on Semantic Analysis