You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Anoop Sam John (JIRA)" <ji...@apache.org> on 2014/02/05 06:44:09 UTC
[jira] [Updated] (PHOENIX-18) Distinct based aggregations not
working correctly when query contains ORDER BY
[ https://issues.apache.org/jira/browse/PHOENIX-18?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sam John updated PHOENIX-18:
----------------------------------
Summary: Distinct based aggregations not working correctly when query contains ORDER BY (was: (count(distinct col)) DESC sort process not working)
> Distinct based aggregations not working correctly when query contains ORDER BY
> ------------------------------------------------------------------------------
>
> 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
> Attachments: PHOENIX-18.patch
>
> 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)