You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ja...@apache.org on 2017/09/15 22:10:26 UTC
svn commit: r1808487 [1/2] - in /phoenix: phoenix-docs/src/docsrc/help/
site/publish/ site/publish/language/ site/source/src/site/
site/source/src/site/markdown/
Author: jamestaylor
Date: Fri Sep 15 22:10:25 2017
New Revision: 1808487
URL: http://svn.apache.org/viewvc?rev=1808487&view=rev
Log:
Doc patches: PHOENIX-4136 APPROXIMATE_COUNT_DISTINCT, PHOENIX-4001 CURSOR, PHOENIX-4137 Document IndexScrutinyTool
Added:
phoenix/site/publish/cursors.html
phoenix/site/source/src/site/markdown/cursors.md
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/atomic_upsert.html
phoenix/site/publish/building.html
phoenix/site/publish/building_website.html
phoenix/site/publish/bulk_dataload.html
phoenix/site/publish/columnencoding.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/hive_storage_handler.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/joins.html
phoenix/site/publish/kafka.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/namspace_mapping.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/phoenixcon.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/tuning_guide.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/secondary_indexing.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=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Fri Sep 15 22:10:25 2017
@@ -70,6 +70,43 @@ DELETE FROM TEST WHERE ID=123;
DELETE FROM TEST WHERE NAME LIKE 'foo%';
"
+"Commands","DECLARE CURSOR","
+DECLARE CURSOR cursorName FOR selectStatement
+","
+Creates a cursor for the select statement
+
+","
+DECLARE CURSOR TEST_CURSOR FOR SELECT * FROM TEST_TABLE
+"
+
+"Commands","OPEN CURSOR","
+OPEN CURSOR cursorName
+","
+Opens already declared cursor to perform FETCH operations
+
+","
+OPEN CURSOR TEST_CURSOR
+"
+
+"Commands","FETCH NEXT","
+FETCH NEXT [n ROWS] FROM cursorName
+","
+Retrieves next or next n rows from already opened cursor
+
+","
+FETCH NEXT FROM TEST_CURSOR
+FETCH NEXT 10 ROWS FROM TEST_CURSOR
+"
+
+"Commands","CLOSE","
+CLOSE cursorName
+","
+Closes an already open cursor
+
+","
+CLOSE TEST_CURSOR
+"
+
"Commands","CREATE TABLE","
CREATE TABLE [IF NOT EXISTS] tableRef
( columnDef [,...] [constraint] )
@@ -1381,6 +1418,18 @@ Aggregates are only allowed in select st
COUNT(*)
"
+"Functions (Aggregate)","APPROX_COUNT_DISTINCT","
+APPROX_COUNT_DISTINCT( { * | { term } } )
+","
+The approximate distinct count of all row, or of the non-null values.
+The relative error of approximation by default is less than 0.00405
+This method returns a long.
+If no rows are selected, the result is 0.
+Aggregates are only allowed in select statements.
+","
+APPROX_COUNT_DISTINCT(*)
+"
+
"Functions (Aggregate)","MAX","
MAX(term)
","
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=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -428,10 +429,13 @@ ORDER BY sum(population) DESC;
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/array_type.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -429,10 +430,13 @@ SELECT region_name FROM regions WHERE '9
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/atomic_upsert.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/atomic_upsert.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/atomic_upsert.html (original)
+++ phoenix/site/publish/atomic_upsert.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -393,10 +394,13 @@ ON DUPLICATE KEY UPDATE
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/building.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -410,10 +411,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/building_website.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -370,10 +371,13 @@ python -m SimpleHTTPServer 8000
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/bulk_dataload.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/bulk_dataload.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/bulk_dataload.html (original)
+++ phoenix/site/publish/bulk_dataload.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li class="active"><a href="" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -540,10 +541,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/columnencoding.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/columnencoding.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/columnencoding.html (original)
+++ phoenix/site/publish/columnencoding.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -474,10 +475,13 @@ COLUMN_ENCODED_BYTES = 1;
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/contributing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/contributing.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/contributing.html (original)
+++ phoenix/site/publish/contributing.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-08-02
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -407,10 +408,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Added: phoenix/site/publish/cursors.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/cursors.html?rev=1808487&view=auto
==============================================================================
--- phoenix/site/publish/cursors.html (added)
+++ phoenix/site/publish/cursors.html Fri Sep 15 22:10:25 2017
@@ -0,0 +1,456 @@
+
+<!DOCTYPE html>
+<!--
+ Generated by Apache Maven Doxia at 2017-09-15
+ Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
+-->
+<html xml:lang="en" lang="en">
+
+ <head>
+ <meta charset="UTF-8" />
+ <title>Cursor | Apache Phoenix</title>
+ <meta name="viewport" content="width=device-width, initial-scale=1.0" />
+ <meta name="description" content="" />
+ <meta http-equiv="content-language" content="en" />
+
+ <link href="//netdna.bootstrapcdn.com/bootswatch/2.3.2/flatly/bootstrap.min.css" rel="stylesheet" />
+ <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/css/bootstrap-responsive.min.css" rel="stylesheet" />
+ <link href="./css/bootswatch.css" rel="stylesheet" />
+ <link href="./css/reflow-skin.css" rel="stylesheet" />
+
+ <link href="//yandex.st/highlightjs/7.5/styles/default.min.css" rel="stylesheet" />
+
+ <link href="./css/lightbox.css" rel="stylesheet" />
+
+ <link href="./css/site.css" rel="stylesheet" />
+ <link href="./css/print.css" rel="stylesheet" media="print" />
+
+ <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
+ <!--[if lt IE 9]>
+ <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
+ <![endif]-->
+
+
+
+ </head>
+
+ <body class="page-cursors project-phoenix-site" data-spy="scroll" data-offset="60" data-target="#toc-scroll-target">
+
+ <div class="navbar navbar-fixed-top">
+ <div class="navbar-inner">
+ <div class="container">
+ <a class="btn btn-navbar" data-toggle="collapse" data-target="#top-nav-collapse">
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ </a>
+ <a class="brand" href="index.html"><div class="xtoplogo"></div></a>
+ <div class="nav-collapse collapse" id="top-nav-collapse">
+ <ul class="nav pull-right">
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="index.html" title="Overview">Overview</a></li>
+ <li ><a href="who_is_using.html" title="Who is Using">Who is Using</a></li>
+ <li ><a href="recent.html" title="Recent Improvements">Recent Improvements</a></li>
+ <li ><a href="roadmap.html" title="Roadmap">Roadmap</a></li>
+ <li ><a href="news.html" title="News">News</a></li>
+ <li ><a href="performance.html" title="Performance">Performance</a></li>
+ <li ><a href="team.html" title="Team">Team</a></li>
+ <li ><a href="resources.html" title="Presentations">Presentations</a></li>
+ <li ><a href="mailing_list.html" title="Mailing Lists">Mailing Lists</a></li>
+ <li ><a href="source.html" title="Source Repository">Source Repository</a></li>
+ <li ><a href="issues.html" title="Issue Tracking">Issue Tracking</a></li>
+ <li ><a href="download.html" title="Download">Download</a></li>
+ <li ><a href="installation.html" title="Installation">Installation</a></li>
+ <li class="divider"/>
+ <li ><a href="contributing.html" title="How to Contribute">How to Contribute</a></li>
+ <li ><a href="develop.html" title="How to Develop">How to Develop</a></li>
+ <li ><a href="building_website.html" title="How to Update Website">How to Update Website</a></li>
+ <li ><a href="release.html" title="How to Release">How to Release</a></li>
+ <li class="divider"/>
+ <li ><a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Using <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="faq.html" title="F.A.Q.">F.A.Q.</a></li>
+ <li ><a href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a></li>
+ <li ><a href="building.html" title="Building">Building</a></li>
+ <li ><a href="tuning_guide.html" title="Tuning">Tuning</a></li>
+ <li ><a href="tuning.html" title="Configuration">Configuration</a></li>
+ <li ><a href="upgrading.html" title="Backward Compatibility">Backward Compatibility</a></li>
+ <li ><a href="release_notes.html" title="Release Notes">Release Notes</a></li>
+ <li ><a href="pherf.html" title="Performance Testing">Performance Testing</a></li>
+ <li class="divider"/>
+ <li ><a href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a></li>
+ <li ><a href="hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive">Phoenix Storage Handler for Apache Hive</a></li>
+ <li ><a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a></li>
+ <li ><a href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a></li>
+ <li ><a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
+ <li ><a href="kafka.html" title="Apache Kafka Plugin">Apache Kafka Plugin</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Addons <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="http://docs.aws.amazon.com/ElasticMapReduce/latest/ReleaseGuide/emr-phoenix.html" title="Phoenix on Amazon EMR" class="externalLink">Phoenix on Amazon EMR</a></li>
+ <li ><a href="http://python-phoenixdb.readthedocs.io/en/latest" title="Phoenix Adapter for Python" class="externalLink">Phoenix Adapter for Python</a></li>
+ <li ><a href="phoenix_orm.html" title="Phoenix ORM Library">Phoenix ORM Library</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Features <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="transactions.html" title="Transactions">Transactions</a></li>
+ <li ><a href="udf.html" title="User-defined Functions">User-defined Functions</a></li>
+ <li class="divider"/>
+ <li ><a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li>
+ <li ><a href="columnencoding.html" title="Storage Formats">Storage Formats</a></li>
+ <li ><a href="atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a></li>
+ <li ><a href="namspace_mapping.html" title="Namespace Mapping">Namespace Mapping</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"/>
+ <li ><a href="views.html" title="Views">Views</a></li>
+ <li ><a href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li>
+ <li ><a href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
+ <li class="divider"/>
+ <li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
+ <li ><a href="server.html" title="Query Server">Query Server</a></li>
+ <li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li class="active"><a href="" title="Cursor">Cursor</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Reference <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="language/index.html" title="Grammar">Grammar</a></li>
+ <li ><a href="language/functions.html" title="Functions">Functions</a></li>
+ <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="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>
+ </ul>
+ </li>
+ </ul>
+ </div><!--/.nav-collapse -->
+ </div>
+ </div>
+ </div>
+
+ <div class="container">
+
+ <!-- Masthead
+ ================================================== -->
+
+ <header>
+ </header>
+
+ <div class="main-body">
+ <div class="row">
+ <div class="span12">
+ <div class="body-content">
+<div class="page-header">
+ <h1>Cursor</h1>
+</div>
+<p>Inorder to be able work on a subset of the rows in a query, Phoenix provides support for CURSOR control structure. The following sequence shows how to use cursor. </p>
+<ol style="list-style-type: decimal">
+ <li> <p>Define cursor for a query using DECLARE statement</p>
+ <div class="source">
+ <pre>PreparedStatement statement = conn.prepareStatement("DECLARE empCursor CURSOR FOR SELECT * FROM EMP_TABLE");
+statement.execute();
+</pre>
+ </div></li>
+ <li> <p>Open the cursor</p>
+ <div class="source">
+ <pre>statement = con.prepareStatement("OPEN empCursor");
+statement.execute();
+</pre>
+ </div></li>
+ <li> <p>Fetch subset of rows to work with</p>
+ <div class="source">
+ <pre>statement = con.prepareStatement("FETCH NEXT 10 ROWS FROM empCursor");
+ResultSet rset = statement.execute();
+</pre>
+ </div></li>
+ <li> <p>Iterate through the subset of rows and process them as required</p>
+ <div class="source">
+ <pre>while (rset.next != null){
+ ...
+}
+</pre>
+ </div></li>
+ <li> <p>Fetch additional set of rows to process and finally close the cursor when done</p>
+ <div class="source">
+ <pre>statement = con.prepareStatement(âCLOSE empCursor");
+statement.execute();
+</pre>
+ </div></li>
+</ol>
+ </div>
+ </div>
+ </div>
+ </div>
+
+ </div><!-- /container -->
+
+ <!-- Footer
+ ================================================== -->
+ <footer class="well">
+ <div class="container">
+ <div class="row">
+ <div class="span2 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">About</li>
+ <li >
+ <a href="index.html" title="Overview">Overview</a>
+ </li>
+ <li >
+ <a href="who_is_using.html" title="Who is Using">Who is Using</a>
+ </li>
+ <li >
+ <a href="recent.html" title="Recent Improvements">Recent Improvements</a>
+ </li>
+ <li >
+ <a href="roadmap.html" title="Roadmap">Roadmap</a>
+ </li>
+ <li >
+ <a href="news.html" title="News">News</a>
+ </li>
+ <li >
+ <a href="performance.html" title="Performance">Performance</a>
+ </li>
+ <li >
+ <a href="team.html" title="Team">Team</a>
+ </li>
+ <li >
+ <a href="resources.html" title="Presentations">Presentations</a>
+ </li>
+ <li >
+ <a href="mailing_list.html" title="Mailing Lists">Mailing Lists</a>
+ </li>
+ <li >
+ <a href="source.html" title="Source Repository">Source Repository</a>
+ </li>
+ <li >
+ <a href="issues.html" title="Issue Tracking">Issue Tracking</a>
+ </li>
+ <li >
+ <a href="download.html" title="Download">Download</a>
+ </li>
+ <li >
+ <a href="installation.html" title="Installation">Installation</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="contributing.html" title="How to Contribute">How to Contribute</a>
+ </li>
+ <li >
+ <a href="develop.html" title="How to Develop">How to Develop</a>
+ </li>
+ <li >
+ <a href="building_website.html" title="How to Update Website">How to Update Website</a>
+ </li>
+ <li >
+ <a href="release.html" title="How to Release">How to Release</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span2 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Using</li>
+ <li >
+ <a href="faq.html" title="F.A.Q.">F.A.Q.</a>
+ </li>
+ <li >
+ <a href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a>
+ </li>
+ <li >
+ <a href="building.html" title="Building">Building</a>
+ </li>
+ <li >
+ <a href="tuning_guide.html" title="Tuning">Tuning</a>
+ </li>
+ <li >
+ <a href="tuning.html" title="Configuration">Configuration</a>
+ </li>
+ <li >
+ <a href="upgrading.html" title="Backward Compatibility">Backward Compatibility</a>
+ </li>
+ <li >
+ <a href="release_notes.html" title="Release Notes">Release Notes</a>
+ </li>
+ <li >
+ <a href="pherf.html" title="Performance Testing">Performance Testing</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a>
+ </li>
+ <li >
+ <a href="hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive">Phoenix Storage Handler for Apache Hive</a>
+ </li>
+ <li >
+ <a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a>
+ </li>
+ <li >
+ <a href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a>
+ </li>
+ <li >
+ <a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a>
+ </li>
+ <li >
+ <a href="kafka.html" title="Apache Kafka Plugin">Apache Kafka Plugin</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span2 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Features</li>
+ <li >
+ <a href="transactions.html" title="Transactions">Transactions</a>
+ </li>
+ <li >
+ <a href="udf.html" title="User-defined Functions">User-defined Functions</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
+ </li>
+ <li >
+ <a href="columnencoding.html" title="Storage Formats">Storage Formats</a>
+ </li>
+ <li >
+ <a href="atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a>
+ </li>
+ <li >
+ <a href="namspace_mapping.html" title="Namespace Mapping">Namespace Mapping</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 >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="views.html" title="Views">Views</a>
+ </li>
+ <li >
+ <a href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a>
+ </li>
+ <li >
+ <a href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
+ </li>
+ <li >
+ <a href="server.html" title="Query Server">Query Server</a>
+ </li>
+ <li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
+ <a href="tracing.html" title="Tracing">Tracing</a>
+ </li>
+ <li class="active">
+ <a href="#" title="Cursor">Cursor</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Reference</li>
+ <li >
+ <a href="language/index.html" title="Grammar">Grammar</a>
+ </li>
+ <li >
+ <a href="language/functions.html" title="Functions">Functions</a>
+ </li>
+ <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 >
+ <a href="http:divider" title=""></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>
+ </ul>
+ </div>
+ <div class="span3 bottom-description">
+ <form action="http://search-hadoop.com/?" method="get"><input value="Phoenix" name="fc_project" type="hidden"><input placeholder="Search Phoenix…" required="required" style="width:170px;" size="18" name="q" id="query" type="search"></form>
+ </div>
+ </div>
+ </div>
+ </footer>
+
+ <div class="container subfooter">
+ <div class="row">
+ <div class="span12">
+ <p class="pull-right"><a href="#">Back to top</a></p>
+ <p class="copyright">Copyright ©2017 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
+ </div>
+ </div>
+ </div>
+
+ <!-- Le javascript
+ ================================================== -->
+ <!-- Placed at the end of the document so the pages load faster -->
+ <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
+
+ <script src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script>
+ <script src="./js/lightbox.js"></script>
+ <script src="./js/jquery.smooth-scroll.min.js"></script>
+ <!-- back button support for smooth scroll -->
+ <script src="./js/jquery.ba-bbq.min.js"></script>
+ <script src="//yandex.st/highlightjs/7.5/highlight.min.js"></script>
+
+ <script src="./js/reflow-skin.js"></script>
+
+ </body>
+</html>
Modified: phoenix/site/publish/develop.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/develop.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/develop.html (original)
+++ phoenix/site/publish/develop.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -646,10 +647,13 @@ git remote add upstream https://github.c
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/download.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/download.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/download.html (original)
+++ phoenix/site/publish/download.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -354,10 +355,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/dynamic_columns.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/dynamic_columns.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/dynamic_columns.html (original)
+++ phoenix/site/publish/dynamic_columns.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -367,10 +368,13 @@ WHERE eventType = 'OOM' AND lastGCTime &
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/faq.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/faq.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/faq.html (original)
+++ phoenix/site/publish/faq.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-27
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -601,10 +602,13 @@ conn.commit();
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/flume.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/flume.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/flume.html (original)
+++ phoenix/site/publish/flume.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -449,10 +450,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/hive_storage_handler.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/hive_storage_handler.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/hive_storage_handler.html (original)
+++ phoenix/site/publish/hive_storage_handler.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -561,10 +562,13 @@ TBLPROPERTIES (
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/index.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/index.html (original)
+++ phoenix/site/publish/index.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-27
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -498,10 +499,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/installation.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/installation.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -412,10 +413,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/issues.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/issues.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/issues.html (original)
+++ phoenix/site/publish/issues.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -353,10 +354,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/joins.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/joins.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/joins.html (original)
+++ phoenix/site/publish/joins.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -765,10 +766,13 @@ ON O.ItemID = I.ItemID;
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/kafka.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/kafka.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/kafka.html (original)
+++ phoenix/site/publish/kafka.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -497,10 +498,13 @@ poll.timeout.ms=100
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-08-18
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="../server.html" title="Query Server">Query Server</a></li>
- <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="../metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="../cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -920,10 +921,13 @@ syntax-end -->
<a href="../server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="../metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="../tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="../metrics.html" title="Metrics">Metrics</a>
+ <a href="../cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-08-18
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="../server.html" title="Query Server">Query Server</a></li>
- <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="../metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="../cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -170,6 +171,8 @@
<a href="#count" >COUNT</a><br />
+ <a href="#approx_count_distinct" >APPROX_COUNT_DISTINCT</a><br />
+
<a href="#max" >MAX</a><br />
<a href="#min" >MIN</a><br />
@@ -206,6 +209,8 @@ syntax-end -->
<a href="#count" >COUNT</a><br />
+ <a href="#approx_count_distinct" >APPROX_COUNT_DISTINCT</a><br />
+
<a href="#max" >MAX</a><br />
<a href="#min" >MIN</a><br />
@@ -222,9 +227,9 @@ syntax-end -->
<a href="#first_value" >FIRST_VALUE</a><br />
<a href="#last_value" >LAST_VALUE</a><br />
- </td><td class="index">
<a href="#first_values" >FIRST_VALUES</a><br />
+ </td><td class="index">
<a href="#last_values" >LAST_VALUES</a><br />
@@ -624,6 +629,24 @@ syntax-end -->
<p>Example:</p>
<p class="notranslate">COUNT(*)</p>
+<h3 id="approx_count_distinct" class="notranslate">APPROX_COUNT_DISTINCT</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+APPROX_COUNT_DISTINCT( { * | { <a href="index.html#term">term</a> } } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">APPROX_COUNT_DISTINCT (</code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">*</code></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c"><a href="index.html#term">term</a></code></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+APPROX_COUNT_DISTINCT( { * | { <a href="index.html#term">term</a> } } )
+</pre>
+syntax-end -->
+<p>The approximate distinct count of all row, or of the non-null values. The relative error of approximation by default is less than 0.00405 This method returns a long. If no rows are selected, the result is 0. Aggregates are only allowed in select statements.</p>
+<p>Example:</p>
+<p class="notranslate">APPROX_COUNT_DISTINCT(*)</p>
+
<h3 id="max" class="notranslate">MAX</h3>
<!-- railroad-start -->
<pre name="bnf" style="display: none">
@@ -2183,10 +2206,13 @@ syntax-end -->
<a href="../server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="../metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="../tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="../metrics.html" title="Metrics">Metrics</a>
+ <a href="../cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/language/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-08-18
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="../server.html" title="Query Server">Query Server</a></li>
- <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="../metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="../cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -174,6 +175,14 @@
<a href="#delete">DELETE</a><br />
+ <a href="#declare_cursor">DECLARE CURSOR</a><br />
+
+ <a href="#open_cursor">OPEN CURSOR</a><br />
+
+ <a href="#fetch_next">FETCH NEXT</a><br />
+
+ <a href="#close">CLOSE</a><br />
+
<a href="#create_table">CREATE TABLE</a><br />
<a href="#drop_table">DROP TABLE</a><br />
@@ -222,12 +231,20 @@ syntax-end -->
<a href="#delete" >DELETE</a><br />
+ <a href="#declare_cursor" >DECLARE CURSOR</a><br />
+
+ <a href="#open_cursor" >OPEN CURSOR</a><br />
+
+ <a href="#fetch_next" >FETCH NEXT</a><br />
+
+ <a href="#close" >CLOSE</a><br />
+
<a href="#create_table" >CREATE TABLE</a><br />
+ </td><td class="index">
<a href="#drop_table" >DROP TABLE</a><br />
<a href="#create_function" >CREATE FUNCTION</a><br />
- </td><td class="index">
<a href="#drop_function" >DROP FUNCTION</a><br />
@@ -587,6 +604,82 @@ syntax-end -->
<p class="notranslate">
DELETE FROM TEST;<br />DELETE FROM TEST WHERE ID=123;<br />DELETE FROM TEST WHERE NAME LIKE 'foo%';</p>
+<h3 id="declare_cursor" class="notranslate">DECLARE CURSOR</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DECLARE CURSOR <a href="index.html#name">cursorName</a> FOR <a href="index.html#select_statement">selectStatement</a>
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">DECLARE CURSOR <a href="index.html#name">cursorName</a> FOR <a href="index.html#select_statement">selectStatement</a></code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DECLARE CURSOR <a href="index.html#name">cursorName</a> FOR <a href="index.html#select_statement">selectStatement</a>
+</pre>
+syntax-end -->
+<p>Creates a cursor for the select statement</p>
+<p>Example:</p>
+<p class="notranslate">
+DECLARE CURSOR TEST_CURSOR FOR SELECT * FROM TEST_TABLE</p>
+
+<h3 id="open_cursor" class="notranslate">OPEN CURSOR</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+OPEN CURSOR <a href="index.html#name">cursorName</a>
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">OPEN CURSOR <a href="index.html#name">cursorName</a></code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+OPEN CURSOR <a href="index.html#name">cursorName</a>
+</pre>
+syntax-end -->
+<p>Opens already declared cursor to perform <code>FETCH</code> operations</p>
+<p>Example:</p>
+<p class="notranslate">
+OPEN CURSOR TEST_CURSOR</p>
+
+<h3 id="fetch_next" class="notranslate">FETCH NEXT</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+FETCH NEXT [n ROWS] FROM <a href="index.html#name">cursorName</a>
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">FETCH NEXT</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">n ROWS</code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">FROM <a href="index.html#name">cursorName</a></code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+FETCH NEXT [n ROWS] FROM <a href="index.html#name">cursorName</a>
+</pre>
+syntax-end -->
+<p>Retrieves next or next n rows from already opened cursor</p>
+<p>Example:</p>
+<p class="notranslate">
+FETCH NEXT FROM TEST_CURSOR<br />FETCH NEXT 10 ROWS FROM TEST_CURSOR</p>
+
+<h3 id="close" class="notranslate">CLOSE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+CLOSE <a href="index.html#name">cursorName</a>
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">CLOSE <a href="index.html#name">cursorName</a></code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+CLOSE <a href="index.html#name">cursorName</a>
+</pre>
+syntax-end -->
+<p>Closes an already open cursor</p>
+<p>Example:</p>
+<p class="notranslate">
+CLOSE TEST_CURSOR</p>
+
<h3 id="create_table" class="notranslate">CREATE TABLE</h3>
<!-- railroad-start -->
<pre name="bnf" style="display: none">
@@ -1880,10 +1973,13 @@ syntax-end -->
<a href="../server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="../metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="../tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="../metrics.html" title="Metrics">Metrics</a>
+ <a href="../cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/mailing_list.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/mailing_list.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/mailing_list.html (original)
+++ phoenix/site/publish/mailing_list.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -392,10 +393,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/metrics.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/metrics.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/metrics.html (original)
+++ phoenix/site/publish/metrics.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li class="active"><a href="" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -467,11 +468,14 @@
<li >
<a href="server.html" title="Query Server">Query Server</a>
</li>
+ <li class="active">
+ <a href="#" title="Metrics">Metrics</a>
+ </li>
<li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
- <li class="active">
- <a href="#" title="Metrics">Metrics</a>
+ <li >
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/multi-tenancy.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -401,10 +402,13 @@ WHERE event_type='L';
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/namspace_mapping.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/namspace_mapping.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/namspace_mapping.html (original)
+++ phoenix/site/publish/namspace_mapping.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -481,10 +482,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/news.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -419,10 +420,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/paged.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/paged.html (original)
+++ phoenix/site/publish/paged.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -402,10 +403,13 @@ LIMIT 10 OFFSET 10
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/performance.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -409,10 +410,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/pherf.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/pherf.html (original)
+++ phoenix/site/publish/pherf.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -475,10 +476,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/phoenix_mr.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_mr.html (original)
+++ phoenix/site/publish/phoenix_mr.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -519,10 +520,13 @@ job.waitForCompletion(true);
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/phoenix_on_emr.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_on_emr.html (original)
+++ phoenix/site/publish/phoenix_on_emr.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -349,10 +350,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/phoenix_orm.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_orm.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_orm.html (original)
+++ phoenix/site/publish/phoenix_orm.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -529,10 +530,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/phoenix_python.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_python.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_python.html (original)
+++ phoenix/site/publish/phoenix_python.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -350,10 +351,13 @@
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>
Modified: phoenix/site/publish/phoenix_spark.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Fri Sep 15 22:10:25 2017
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-07-24
+ Generated by Apache Maven Doxia at 2017-09-15
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -122,8 +122,9 @@
<li class="divider"/>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="server.html" title="Query Server">Query Server</a></li>
- <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -602,10 +603,13 @@ pr.vertices.saveToPhoenix("EMAIL_EN
<a href="server.html" title="Query Server">Query Server</a>
</li>
<li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ <li >
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
- <a href="metrics.html" title="Metrics">Metrics</a>
+ <a href="cursors.html" title="Cursor">Cursor</a>
</li>
</ul>
</div>