[ 
https://issues.apache.org/jira/browse/PHOENIX-1192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14105296#comment-14105296
 ] 

Hudson commented on PHOENIX-1192:
---------------------------------

FAILURE: Integrated in Phoenix | 4.0 | Hadoop2 #55 (See 
[https://builds.apache.org/job/Phoenix-4.0-hadoop2/55/])
PHOENIX-1192 Re-enable reverse scan to prevent order by (jtaylor: rev 
e2922d43c094fa200fd5a3baf6a676f38a121f94)
* phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/DegenerateQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ScanPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BasicQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ReverseScanIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/MutableIndexIT.java
* phoenix-core/src/main/java/org/apache/phoenix/query/QueryServicesOptions.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/AggregatePlan.java
* 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/BaseScannerRegionObserver.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OrderByCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/HashJoinPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* 
phoenix-core/src/main/java/org/apache/phoenix/iterate/ChunkedResultIterator.java
* 
phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServices.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java


> Re-enable reverse scan to prevent order by
> ------------------------------------------
>
>                 Key: PHOENIX-1192
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1192
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0, 4.1
>            Reporter: James Taylor
>             Fix For: 5.0.0, 4.1
>
>         Attachments: PHOENIX-1192.patch
>
>
> We have code in place and tested for usage of the reverse scan. It's just 
> turned off because the reverse scan ability never made it to 0.94. Now that 
> we have 4.x on top of 0.98, we should turn this back on. It's used to 
> optimize queries that do an ORDER BY in the descending order of the PK (to 
> prevent the standard and expensive order by processing). Prior tests have 
> shown a dramatic difference between the two ways of executing the query.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to