[jira] [Reopened] (PHOENIX-18) (count(distinct col)) DESC sort process not working

["Anoop Sam John (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-18?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anoop Sam John reopened PHOENIX-18:
-----------------------------------

      Assignee: Anoop Sam John

This is a bug. I am working on this one and know the reason now.  Will give patch soon.

>  (count(distinct col)) DESC sort process not working
> ----------------------------------------------------
>
>                 Key: PHOENIX-18
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-18
>             Project: Phoenix
>          Issue Type: Bug
>         Environment: Cloudera 4.5
>            Reporter: saravanan
>            Assignee: Anoop Sam John
>   Original Estimate: 12h
>  Remaining Estimate: 12h
>
> I run the below query and not getting the expected result...
> SELECT "tbp__VPN" as "Part Number",Count(distinct "tbp__EGN") as "egn Number" FROM "AL_V_PNO_DEMO" WHERE ("tbp__VPN" 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.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)