Author: ankit
Date: Thu Aug 11 07:29:03 2016
New Revision: 1755911
URL: http://svn.apache.org/viewvc?rev=1755911&view=rev
Log:
PHOENIX-2821 Document Offset and Fetch SQL construct
Modified:
phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
phoenix/site/publish/array_type.html
phoenix/site/publish/building.html
phoenix/site/publish/building_website.html
phoenix/site/publish/bulk_dataload.html
phoenix/site/publish/contributing.html
phoenix/site/publish/develop.html
phoenix/site/publish/download.html
phoenix/site/publish/dynamic_columns.html
phoenix/site/publish/faq.html
phoenix/site/publish/flume.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/joins.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/mailing_list.html
phoenix/site/publish/metrics.html
phoenix/site/publish/multi-tenancy.html
phoenix/site/publish/news.html
phoenix/site/publish/paged.html
phoenix/site/publish/performance.html
phoenix/site/publish/pherf.html
phoenix/site/publish/phoenix_mr.html
phoenix/site/publish/phoenix_on_emr.html
phoenix/site/publish/phoenix_orm.html
phoenix/site/publish/phoenix_python.html
phoenix/site/publish/phoenix_spark.html
phoenix/site/publish/pig_integration.html
phoenix/site/publish/recent.html
phoenix/site/publish/release.html
phoenix/site/publish/release_notes.html
phoenix/site/publish/resources.html
phoenix/site/publish/roadmap.html
phoenix/site/publish/rowtimestamp.html
phoenix/site/publish/salted.html
phoenix/site/publish/secondary_indexing.html
phoenix/site/publish/sequences.html
phoenix/site/publish/server.html
phoenix/site/publish/skip_scan.html
phoenix/site/publish/source.html
phoenix/site/publish/subqueries.html
phoenix/site/publish/team.html
phoenix/site/publish/tracing.html
phoenix/site/publish/transactions.html
phoenix/site/publish/tuning.html
phoenix/site/publish/udf.html
phoenix/site/publish/update_statistics.html
phoenix/site/publish/upgrading.html
phoenix/site/publish/views.html
phoenix/site/publish/who_is_using.html
phoenix/site/source/src/site/markdown/paged.md
phoenix/site/source/src/site/site.xml
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
URL:
http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Thu Aug 11 07:29:03 2016
@@ -2,13 +2,15 @@
"Commands","SELECT","
selectStatement [ { UNION ALL selectStatement [...] } ]
[ ORDER BY order [,...] ] [ LIMIT {bindParameter | number} ]
+[ OFFSET {bindParameter | number} [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT }
{bindParameter | number} { ROW | ROWS } ONLY ]
","
Selects data from one or more tables.
UNION ALL combines rows from multiple select statements.
ORDER BY sorts the result based on the given expressions.
-LIMIT limits the number of rows returned by the query with no limit applied if
unspecified or specified
-as null or less than zero. The LIMIT clause is executed after the ORDER BY
clause to support top-N type
+LIMIT(or FETCH FIRST) limits the number of rows returned by the query with no
limit applied if unspecified or specified
+as null or less than zero. The LIMIT(or FETCH FIRST) clause is executed after
the ORDER BY clause to support top-N type
queries.
+OFFSET clause skips that many rows before beginning to return rows.
An optional hint may be used to override decisions made by the query optimizer.
","
Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/Phoenix-in-15-minutes-or-less.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Thu Aug 11 07:29:03
2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -378,6 +378,9 @@ ORDER BY sum(population) DESC;
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -431,9 +434,6 @@ ORDER BY sum(population) DESC;
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/array_type.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li
class="active"><a href="" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -379,6 +379,9 @@ SELECT region_name FROM regions WHERE '9
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -432,9 +435,6 @@ SELECT region_name FROM regions WHERE '9
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/building.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -360,6 +360,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -413,9 +416,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/building_website.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -319,6 +319,9 @@ python -m SimpleHTTPServer 8000
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -372,9 +375,6 @@ python -m SimpleHTTPServer 8000
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/bulk_dataload.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/bulk_dataload.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/bulk_dataload.html (original)
+++ phoenix/site/publish/bulk_dataload.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -480,6 +480,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -533,9 +536,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/contributing.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/contributing.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/contributing.html (original)
+++ phoenix/site/publish/contributing.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -357,6 +357,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -410,9 +413,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/develop.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/develop.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/develop.html (original)
+++ phoenix/site/publish/develop.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -596,6 +596,9 @@ git remote add upstream https://github.c
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -649,9 +652,6 @@ git remote add upstream https://github.c
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/download.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/download.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/download.html (original)
+++ phoenix/site/publish/download.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -304,6 +304,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -357,9 +360,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/dynamic_columns.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/dynamic_columns.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/dynamic_columns.html (original)
+++ phoenix/site/publish/dynamic_columns.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -317,6 +317,9 @@ WHERE eventType = 'OOM' AND lastGCTime &
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -370,9 +373,6 @@ WHERE eventType = 'OOM' AND lastGCTime &
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/faq.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/faq.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/faq.html (original)
+++ phoenix/site/publish/faq.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -525,6 +525,9 @@ conn.commit();
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -578,9 +581,6 @@ conn.commit();
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/flume.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/flume.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/flume.html (original)
+++ phoenix/site/publish/flume.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -399,6 +399,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -452,9 +455,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/index.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/index.html (original)
+++ phoenix/site/publish/index.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -447,6 +447,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -500,9 +503,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/installation.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/installation.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -362,6 +362,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -415,9 +418,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/issues.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/issues.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/issues.html (original)
+++ phoenix/site/publish/issues.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -303,6 +303,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -356,9 +359,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/joins.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/joins.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/joins.html (original)
+++ phoenix/site/publish/joins.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li
class="active"><a href="" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -715,6 +715,9 @@ ON O.ItemID = I.ItemID;
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -768,9 +771,6 @@ ON O.ItemID = I.ItemID;
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li class="active">
Modified: phoenix/site/publish/language/datatypes.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="../secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="../update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="../paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="../salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li
class="active"><a href="" title="Datatypes">Datatypes</a></li>
<li ><a
href="../array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="../paged.html" title="Row Value Constructors">Row Value
Constructors</a></li>
<li ><a
href="../sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="../joins.html" title="Joins">Joins</a></li>
<li ><a
href="../subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -870,6 +870,9 @@ syntax-end -->
<a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a>
</li>
<li >
+ <a href="../paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a
href="../salted.html" title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -923,9 +926,6 @@ syntax-end -->
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="../paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="../sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/language/functions.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="../secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="../update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="../paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="../salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="../array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="../paged.html" title="Row Value Constructors">Row Value
Constructors</a></li>
<li ><a
href="../sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="../joins.html" title="Joins">Joins</a></li>
<li ><a
href="../subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -1913,6 +1913,9 @@ syntax-end -->
<a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a>
</li>
<li >
+ <a href="../paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a
href="../salted.html" title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -1966,9 +1969,6 @@ syntax-end -->
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="../paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="../sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/language/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-21
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="../secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="../update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="../paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="../salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="../array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="../paged.html" title="Row Value Constructors">Row Value
Constructors</a></li>
<li ><a
href="../sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="../joins.html" title="Joins">Joins</a></li>
<li ><a
href="../subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -485,18 +485,20 @@ syntax-end -->
<pre name="bnf" style="display: none">
<a href="index.html#select_statement">selectStatement</a> [ { UNION ALL <a
href="index.html#select_statement">selectStatement</a> [...] } ]
[ ORDER BY <a href="index.html#order">order</a> [,...] ] [ LIMIT {<a
href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} ]
+[ OFFSET {<a href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT }
{<a href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} { ROW | ROWS } ONLY ]
</pre>
<div name="railroad">
-<table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a
href="index.html#select_statement">selectStatement</a></code></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="d"><code class="c">UNION ALL <a
href="index.html#select_statement">selectStatement</a></code></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">...</code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table><br /><table
class="railroad"><tr class="railroad"><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="ra
ilroad"><td class="ls"></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="d"><code class="c">ORDER BY <a
href="index.html#order">order</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">LIMIT</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"><code class="c"><a
href="index.html#bind_parameter">bindParameter</a></code></td><td
class="te"></td></tr><tr class="railroad"><td class="ls"><
/td><td class="d"><code class="c"><a
href="index.html#number">number</a></code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a
href="index.html#select_statement">selectStatement</a></code></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="d"><code class="c">UNION ALL <a
href="index.html#select_statement">selectStatement</a></code></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">...</code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table><br /><table
class="railroad"><tr class="railroad"><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="ra
ilroad"><td class="ls"></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="d"><code class="c">ORDER BY <a
href="index.html#order">order</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">LIMIT</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"><code class="c"><a
href="index.html#bind_parameter">bindParameter</a></code></td><td
class="te"></td></tr><tr class="railroad"><td class="ls"><
/td><td class="d"><code class="c"><a
href="index.html#number">number</a></code></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table><br /><table
class="railroad"><tr class="railroad"><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">OFFSET</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"><code class="c"><a
href="index.html#bind_parameter">bindParameter</a></code></td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><code class="c"><a href="index.html#number">number</a></code></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td class="te"><
/td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code
class="c">ROW</code></td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">ROWS</code></td><td
class="le"></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">FETCH</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"><code
class="c">FIRST</code></td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">NEXT</code></td><td
class="le"></td></tr></table></td><td class="d"><table class=
"railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code
class="c"><a href="index.html#bind_parameter">bindParameter</a></code></td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><code class="c"><a href="index.html#number">number</a></code></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"><code
class="c">ROW</code></td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">ROWS</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">ONLY</code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
</div>
<!-- railroad-end -->
<!-- syntax-start
<pre>
<a href="index.html#select_statement">selectStatement</a> [ { UNION ALL <a
href="index.html#select_statement">selectStatement</a> [...] } ]
[ ORDER BY <a href="index.html#order">order</a> [,...] ] [ LIMIT {<a
href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} ]
+[ OFFSET {<a href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT }
{<a href="index.html#bind_parameter">bindParameter</a> | <a
href="index.html#number">number</a>} { ROW | ROWS } ONLY ]
</pre>
syntax-end -->
-<p>Selects data from one or more tables. <code>UNION ALL</code> combines rows
from multiple select statements. <code>ORDER BY</code> sorts the result based
on the given expressions. <code>LIMIT</code> limits the number of rows returned
by the query with no limit applied if unspecified or specified as null or less
than zero. The <code>LIMIT</code> clause is executed after the <code>ORDER
BY</code> clause to support top-N type queries. An optional hint may be used to
override decisions made by the query optimizer.</p>
+<p>Selects data from one or more tables. <code>UNION ALL</code> combines rows
from multiple select statements. <code>ORDER BY</code> sorts the result based
on the given expressions. <code>LIMIT</code>(or <code>FETCH FIRST</code>)
limits the number of rows returned by the query with no limit applied if
unspecified or specified as null or less than zero. The <code>LIMIT</code>(or
<code>FETCH FIRST</code>) clause is executed after the <code>ORDER BY</code>
clause to support top-N type queries. <code>OFFSET</code> clause skips that
many rows before beginning to return rows. An optional hint may be used to
override decisions made by the query optimizer.</p>
<p>Example:</p>
<p class="notranslate">
SELECT * FROM TEST LIMIT 1000;<br />SELECT full_name FROM SALES_PERSON WHERE
ranking >= 5.0<br /> UNION ALL SELECT reviewer_name
FROM CUSTOMER_REVIEW WHERE score >= 8.0</p>
@@ -1756,6 +1758,9 @@ syntax-end -->
<a
href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a>
</li>
<li >
+ <a href="../paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a
href="../salted.html" title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -1809,9 +1814,6 @@ syntax-end -->
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="../paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="../sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/mailing_list.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/mailing_list.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/mailing_list.html (original)
+++ phoenix/site/publish/mailing_list.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -342,6 +342,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -395,9 +398,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/metrics.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/metrics.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/metrics.html (original)
+++ phoenix/site/publish/metrics.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -418,6 +418,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -471,9 +474,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/multi-tenancy.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -351,6 +351,9 @@ WHERE event_type='L';
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -404,9 +407,6 @@ WHERE event_type='L';
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/news.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -349,6 +349,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -402,9 +405,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/paged.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/paged.html (original)
+++ phoenix/site/publish/paged.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li
class="active"><a href="" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li
class="active"><a href="" title="Row Value Constructors">Row Value
Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -149,7 +149,13 @@
<div class="page-header">
<h1>Paged Queries</h1>
</div>
-<p>Phoenix supports the use in queries of row value constructors (RVC), a
standard SQL construct to enable paged queries. A row value constructor is an
ordered sequence of values delimited by parentheses. For example:</p>
+<p>Phoenix supports , standard SQL constructs to enable paged queries </p>
+<ul>
+ <li>Row Value Constructors (RVC)</li>
+ <li>OFFSET with limit</li>
+</ul>
+<p><b>Row Value Constructors (RVC)</b></p>
+<p>A row value constructor is an ordered sequence of values delimited by
parentheses. For example:</p>
<div class="source">
<pre>(4, 'foo', 3.5)
('Doe', 'Jane')
@@ -184,7 +190,19 @@ ORDER BY title, author, isbn
LIMIT 20
</pre>
</div>
-<p>Assuming that the client binds the three bind variables to the values of
the last row processed, the next invocation would find the next 20 rows that
match the query. If the columns you supply in your row value constructor match
in order the columns from your primary key (or from a secondary index), then
Phoenix will be able to turn the row value constructor expression into the
start row of your scan. This enables a very efficient mechanism to locate <i>at
or after</i> a row.</p>
+<p>Assuming that the client binds the three bind variables to the values of
the last row processed, the next invocation would find the next 20 rows that
match the query. If the columns you supply in your row value constructor match
in order the columns from your primary key (or from a secondary index), then
Phoenix will be able to turn the row value constructor expression into the
start row of your scan. This enables a very efficient mechanism to locate <i>at
or after</i> a row.</p>
+<p><b>OFFSET with LIMIT</b></p>
+<p>Use OFFSET to specify the starting row offset into the result set returned
by your query and LIMIT to specify the page size.</p>
+<p>For example, If page size is 10, then to select second page, following
queries can be used(rows will be returned from 11 to 20):</p>
+<div class="source">
+ <pre>SELECT title, author, isbn, description
+FROM library
+WHERE published_date > 2010
+ORDER BY title, author, isbn
+OFFSET 10 LIMIT 10
+</pre>
+</div>
+<p>Offset reads and skips the rows on the server or client depending upon the
type of the query whereas RVC is effective for queries reading on primary axis
as it can simply starts from the key provided.</p>
</div>
</div>
</div>
@@ -333,6 +351,9 @@ LIMIT 20
<li >
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
+ <li class="active">
+ <a href="#"
title="Paged Queries">Paged Queries</a>
+ </li>
<li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
@@ -386,9 +407,6 @@ LIMIT 20
<li >
<a href="http:divider"
title=""></a>
</li>
- <li class="active">
- <a href="#" title="Row
Value Constructors">Row Value Constructors</a>
- </li>
<li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
Modified: phoenix/site/publish/performance.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -359,6 +359,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -412,9 +415,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/pherf.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/pherf.html (original)
+++ phoenix/site/publish/pherf.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -439,6 +439,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -492,9 +495,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/phoenix_mr.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_mr.html (original)
+++ phoenix/site/publish/phoenix_mr.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -469,6 +469,9 @@ job.waitForCompletion(true);
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -522,9 +525,6 @@ job.waitForCompletion(true);
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/phoenix_on_emr.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_on_emr.html (original)
+++ phoenix/site/publish/phoenix_on_emr.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -299,6 +299,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -352,9 +355,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/phoenix_orm.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_orm.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_orm.html (original)
+++ phoenix/site/publish/phoenix_orm.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -479,6 +479,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -532,9 +535,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/phoenix_python.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_python.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_python.html (original)
+++ phoenix/site/publish/phoenix_python.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -300,6 +300,9 @@
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -353,9 +356,6 @@
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
Modified: phoenix/site/publish/phoenix_spark.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1755911&r1=1755910&r2=1755911&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Thu Aug 11 07:29:03 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-07-18
+ Generated by Apache Maven Doxia at 2016-08-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -101,6 +101,7 @@
<li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
<li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
<li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
+ <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
<li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
<li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li
class="divider"/>
@@ -122,7 +123,6 @@
<li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
<li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
<li
class="divider"/>
- <li ><a
href="paged.html" title="Row Value Constructors">Row Value Constructors</a></li>
<li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
<li ><a
href="joins.html" title="Joins">Joins</a></li>
<li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
@@ -551,6 +551,9 @@ pr.vertices.saveToPhoenix("EMAIL_EN
<a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
</li>
<li >
+ <a href="paged.html"
title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
<a href="salted.html"
title="Salted Tables">Salted Tables</a>
</li>
<li >
@@ -604,9 +607,6 @@ pr.vertices.saveToPhoenix("EMAIL_EN
<a href="http:divider"
title=""></a>
</li>
<li >
- <a href="paged.html"
title="Row Value Constructors">Row Value Constructors</a>
- </li>
- <li >
<a
href="sequences.html" title="Sequences">Sequences</a>
</li>
<li >
