[
https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15231996#comment-15231996
]
Hudson commented on PHOENIX-2722:
---------------------------------
FAILURE: Integrated in Phoenix-master #1187 (See
[https://builds.apache.org/job/Phoenix-master/1187/])
PHOENIX-2722 support mysql offset clause (ankitsinghal59: rev
776eea9ce1c4828f959b9ef76dd244941972f6ec)
* phoenix-core/src/main/java/org/apache/phoenix/iterate/TableResultIterator.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeFactory.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/DelegateQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/SerialIterators.java
*
phoenix-core/src/main/java/org/apache/phoenix/execute/ClientProcessingPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/UnionPlan.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryWithOffsetIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/DeleteCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/CreateTableIT.java
* phoenix-core/src/test/java/org/apache/phoenix/execute/CorrelatePlanTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/ScanRegionObserver.java
*
phoenix-core/src/main/java/org/apache/phoenix/execute/LiteralResultIterationPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/util/QueryUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OffsetCompiler.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/HashJoinIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/SelectStatement.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/SubselectRewriter.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/SubqueryRewriter.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/TraceQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeRewriter.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OrderByCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java
*
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/BaseScannerRegionObserver.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ScanPlan.java
*
phoenix-core/src/main/java/org/apache/phoenix/iterate/MergeSortTopNResultIterator.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/DeleteStatement.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/FilterableStatement.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ExplainTable.java
*
phoenix-core/src/main/java/org/apache/phoenix/iterate/OrderedResultIterator.java
*
phoenix-core/src/main/java/org/apache/phoenix/iterate/LimitingResultIterator.java
*
phoenix-core/src/test/java/org/apache/phoenix/execute/LiteralResultIteratorPlanTest.java
* phoenix-core/src/main/antlr3/PhoenixSQL.g
* phoenix-core/src/main/java/org/apache/phoenix/parse/OffsetNode.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/SortMergeJoinPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/AggregatePlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ClientScanPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/StatementNormalizer.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/ListJarsQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/DegenerateQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/join/HashJoinInfo.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ClientAggregatePlan.java
* phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ReadOnlyIT.java
* phoenix-core/src/main/java/org/apache/phoenix/optimize/QueryOptimizer.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/PostDDLCompiler.java
*
phoenix-core/src/main/java/org/apache/phoenix/iterate/OffsetResultIterator.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/AutoCommitIT.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java
*
phoenix-core/src/test/java/org/apache/phoenix/query/ParallelIteratorsSplitTest.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SortMergeJoinIT.java
*
phoenix-core/src/main/java/org/apache/phoenix/iterate/OrderedAggregatingResultIterator.java
* phoenix-core/src/test/java/org/apache/phoenix/execute/UnnestArrayPlanTest.java
> support mysql "limit,offset" clauses
> -------------------------------------
>
> Key: PHOENIX-2722
> URL: https://issues.apache.org/jira/browse/PHOENIX-2722
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Ankit Singhal
> Assignee: Ankit Singhal
> Priority: Minor
> Fix For: 4.8.0
>
> Attachments: PHOENIX-2722.patch, PHOENIX-2722_formatted.patch,
> PHOENIX-2722_v1_rebased.patch
>
>
> For serial query(query with “serial" hint or “limit" without "order by”), we
> can limit each scan(using page filter) to “limit+offset” instead of limit
> earlier.
> And then, for all queries, we can forward the relevant client iterators to
> the offset provided and then return the result.
> syntax
> {code}
> [ LIMIT { count } ]
> [ OFFSET start [ ROW | ROWS ] ]
> [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
> {code}
> Some new keywords(OFFSET,FETCH,ROW, ROWS,ONLY) are getting introduced so
> users might need to see that they are not using them as column name or
> something.
> WDYT, [~jamestaylor]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
