[
https://issues.apache.org/jira/browse/PHOENIX-18?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13891883#comment-13891883
]
Hudson commented on PHOENIX-18:
-------------------------------
SUCCESS: Integrated in Apache Phoenix - Build:master #31 (See
[https://builds.apache.org/job/Phoenix/31/])
PHOENIX-18 Distinct based aggregations not working correctly when query
contains ORDER BY.(Anoop) (anoopsamjohn: rev
4e2398404f5672df4f1160099f3d9a4a681c8445)
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/BaseDecimalStddevAggregator.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/PercentileDiscClientAggregator.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/DistinctCountClientAggregator.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/DistinctValueWithCountClientAggregator.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/BaseStddevAggregator.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/PercentRankClientAggregator.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/DistinctCountTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/PercentileClientAggregator.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/PercentileTest.java
> 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
> Fix For: 3.0.0
>
> 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)
