[jira] [Commented] (PHOENIX-1192) Re-enable reverse scan to prevent order by

["Hudson (JIRA)" <ji...@apache.org>]

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

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

SUCCESS: Integrated in Phoenix | Master | Hadoop1 #343 (See [https://builds.apache.org/job/Phoenix-master-hadoop1/343/])
PHOENIX-1192 Re-enable reverse scan to prevent order by (jtaylor: rev 52b0e0050efca5dd5a49f6844230fd972207022f)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BasicQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/coprocessor/BaseScannerRegionObserver.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/MutableIndexIT.java
* phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java
* phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServices.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ScanPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/query/QueryServicesOptions.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ReverseScanIT.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/AggregatePlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/DegenerateQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/HashJoinPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ChunkedResultIterator.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OrderByCompiler.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)