phoenix-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From an...@apache.org
Subject svn commit: r1755911 [1/2] - in /phoenix: phoenix-docs/src/docsrc/help/ site/publish/ site/publish/language/ site/source/src/site/ site/source/src/site/markdown/
Date Thu, 11 Aug 2016 07:29:04 GMT
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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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 &gt;= 5.0<br />&nbsp;&nbsp;&nbsp;&nbsp;UNION ALL SELECT reviewer_name FROM CUSTOMER_REVIEW WHERE score &gt;= 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 &gt; 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(&quot;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(&quot;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 >




Mime
View raw message