Re: problem in sort for (count(distinct col))...

[James Taylor <ja...@apache.org>]

Hi,
That sounds like a bug. If you could log a JIRA for us and put together a
small unit test,  we'll get it fixed.
Thanks,
James

On Thursday, January 30, 2014, Saravanan A <sa...@ymail.com> wrote:

>
> Hi Phoenix,
> I am new to phoenix and am using it for my poc. 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...Any
> help??????
>
>
>
> Thanks,
>
>
>