phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: problem in sort for (count(distinct col))...
Date Thu, 30 Jan 2014 16:24:04 GMT
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 <saravanan090@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,
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message