[PHOENIX-18] Distinct based aggregations not working correctly when query contains ORDER BY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0

Environment

Cloudera 4.5

• Assignee: Anoop Sam John
• Reporter: saravanan
• Created: 31/Jan/14 09:40
• Updated: 21/Nov/15 02:18
• Resolved: 05/Feb/14 06:13

Description

I run the below query and not getting the expected result...

SELECT "tbp_VPN" as "Part Number",Count(distinct "tbpEGN") as "egn Number" FROM "AL_V_PNO_DEMO" WHERE ("tbpVPN" is not null) GROUP BY "tbp_VPN" ORDER BY 'egn Number' DESC /* +SKIP_SCAN */;

the above query executes fine but the sorting is not done for ORDER BY column..Is its problem with the Query or Its some Bug in Phoenix.