saravanan created PHOENIX-18:
--------------------------------
Summary: problem in sort for (count(distinct col)) DESC
Key: PHOENIX-18
URL: https://issues.apache.org/jira/browse/PHOENIX-18
Project: Phoenix
Issue Type: Bug
Environment: Cloudera 4.5
Reporter: saravanan
I run the below query and not getting the expected result...
SELECT "tbp__VPN" as "Part Number",Count(distinct "tbp__EGN") as "Part Number"
FROM "AL_V_PNO_DEMO" WHERE ("tbp__VPN" is not null) GROUP BY "tbp__VPN" ORDER
BY 'Part 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.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
