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 [2/2] - in /phoenix: phoenix-docs/src/docsrc/help/
site/publish/ site/publish/language/ site/source/src/site/
site/source/src/site/markdown/
Modified: phoenix/site/publish/phoenixcon.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenixcon.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/phoenixcon.html (original)
+++ phoenix/site/publish/phoenixcon.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">
@@ -368,10 +369,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/pig_integration.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/pig_integration.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/pig_integration.html (original)
+++ phoenix/site/publish/pig_integration.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">
@@ -418,10 +419,13 @@ DUMP cnt;
<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/recent.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/recent.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/recent.html (original)
+++ phoenix/site/publish/recent.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">
@@ -391,10 +392,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/release.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/release.html (original)
+++ phoenix/site/publish/release.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">
@@ -376,10 +377,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/release_notes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release_notes.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/release_notes.html (original)
+++ phoenix/site/publish/release_notes.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">
@@ -403,10 +404,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/resources.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/resources.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/resources.html (original)
+++ phoenix/site/publish/resources.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">
@@ -445,10 +446,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/roadmap.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/roadmap.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/roadmap.html (original)
+++ phoenix/site/publish/roadmap.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">
@@ -375,10 +376,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/rowtimestamp.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/rowtimestamp.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/rowtimestamp.html (original)
+++ phoenix/site/publish/rowtimestamp.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">
@@ -364,10 +365,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/salted.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/salted.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/salted.html (original)
+++ phoenix/site/publish/salted.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">
@@ -372,10 +373,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/secondary_indexing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/secondary_indexing.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/secondary_indexing.html (original)
+++ phoenix/site/publish/secondary_indexing.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">
@@ -463,6 +464,73 @@ CREATE LOCAL INDEX my_index ON my_table
<p>That said, we have seen secondary indexing (both immutable and mutable) go as quickly as < 2x the regular write path on a small, (3 node) desktop-based cluster. This is actually pretty reasonable as we have to write to multiple tables as well as build the index update.</p>
</div>
<div class="section">
+ <h2 id="Index_Scrutiny_Tool">Index Scrutiny Tool</h2>
+ <p>With Phoenix 4.12, there is now a tool to run a MapReduce job to verify that an index table is valid against its data table. The only way to find orphaned rows in either table is to scan over all rows in the table and do a lookup in the other table for the corresponding row. For that reason, the tool can run with either the data or index table as the âsourceâ table, and the other as the âtargetâ table. The tool writes all invalid rows it finds either to file or to an output table PHOENIX_INDEX_SCRUTINY. An invalid row is a source row that either has no corresponding row in the target table, or has an incorrect value in the target table (i.e. covered column value).</p>
+ <p>The tool has job counters that track its status. <tt>VALID_ROW_COUNT</tt>, <tt>INVALID_ROW_COUNT</tt>, <tt>BAD_COVERED_COL_VAL_COUNT</tt>. Note that invalid rows - bad col val rows = number of orphaned rows. These counters are written to the table PHOENIX_INDEX_SCRUTINY_METADATA, along with other job metadata.</p>
+ <p>The Index Scrutiny Tool can be launched via the <tt>hbase</tt> command (in hbase/bin) as follows:</p>
+ <div class="source">
+ <pre>hbase org.apache.phoenix.mapreduce.index.IndexScrutinyTool -dt my_table -it my_index -o
+</pre>
+ </div>
+ <p>It can also be run from Hadoop using either the phoenix-core or phoenix-server jar as follows:</p>
+ <div class="source">
+ <pre>HADOOP_CLASSPATH=$(hbase mapredcp) hadoop jar phoenix-<version>-server.jar org.apache.phoenix.mapreduce.index.IndexScrutinyTool -dt my_table -it my_index -o
+</pre>
+ </div>
+ <p>By default two mapreduce jobs are launched, one with the data table as the source table and one with the index table as the source table.</p>
+ <p>The following parameters can be used with the Index Scrutiny Tool:</p>
+ <table border="0" class="bodyTable table table-striped table-hover">
+ <thead>
+ <tr class="a">
+ <th><i>Parameter</i> </th>
+ <th><i>Description</i> </th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr class="b">
+ <td>-dt,âdata-table </td>
+ <td>Data table name (mandatory) </td>
+ </tr>
+ <tr class="a">
+ <td>-it,âindex-table </td>
+ <td>Index table name (mandatory) </td>
+ </tr>
+ <tr class="b">
+ <td>-s,âschema </td>
+ <td>Phoenix schema name (optional) </td>
+ </tr>
+ <tr class="a">
+ <td>-src,âsource </td>
+ <td>DATA_TABLE_SOURCE, INDEX_TABLE_SOURCE, or BOTH. Defaults to BOTH </td>
+ </tr>
+ <tr class="b">
+ <td>-o,âoutput </td>
+ <td>Whether to output invalid rows. Off by default </td>
+ </tr>
+ <tr class="a">
+ <td>-of,âoutput-format </td>
+ <td>TABLE or FILE output format. Defaults to TABLE </td>
+ </tr>
+ <tr class="b">
+ <td>-om,âoutput-max </td>
+ <td>Maximum number of invalid rows to output per mapper. Defaults to 1M </td>
+ </tr>
+ <tr class="a">
+ <td>-op,âoutput-path </td>
+ <td>For FILE output format, the HDFS directory where files are written</td>
+ </tr>
+ <tr class="b">
+ <td>-t,âtime </td>
+ <td>Timestamp in millis at which to run the scrutiny. This is important so that incoming writes donât throw off the scrutiny. Defaults to current time minus 60 seconds </td>
+ </tr>
+ <tr class="a">
+ <td>-b,âbatch-size </td>
+ <td>Number of rows to compare at a time </td>
+ </tr>
+ </tbody>
+ </table>
+</div>
+<div class="section">
<h2 id="Resources">Resources</h2>
<p>There have been several presentations given on how secondary indexing works in Phoenix that have a more in-depth look at how indexing works (with pretty pictures!):</p>
<ul>
@@ -661,10 +729,13 @@ CREATE LOCAL INDEX my_index ON my_table
<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/sequences.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/sequences.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/sequences.html (original)
+++ phoenix/site/publish/sequences.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">
@@ -403,10 +404,13 @@ VALUES( NEXT VALUE FOR my_schema.my_sequ
<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/server.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/server.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/server.html (original)
+++ phoenix/site/publish/server.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 class="active"><a href="" 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">
@@ -651,10 +652,13 @@ log4j.logger.org.eclipse.jetty.server=IN
<a href="#" 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/skip_scan.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/skip_scan.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/skip_scan.html (original)
+++ phoenix/site/publish/skip_scan.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">
@@ -361,10 +362,13 @@ AND KEY2 IN (1, 2)
<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/source.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/source.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/source.html (original)
+++ phoenix/site/publish/source.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 @@
<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/subqueries.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/subqueries.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/subqueries.html (original)
+++ phoenix/site/publish/subqueries.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">
@@ -505,10 +506,13 @@ ORDER BY count(*) 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/team.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/team.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/team.html (original)
+++ phoenix/site/publish/team.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">
@@ -548,10 +549,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/tracing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tracing.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/tracing.html (original)
+++ phoenix/site/publish/tracing.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 class="active"><a href="" title="Tracing">Tracing</a></li>
<li ><a href="metrics.html" title="Metrics">Metrics</a></li>
+ <li class="active"><a href="" title="Tracing">Tracing</a></li>
+ <li ><a href="cursors.html" title="Cursor">Cursor</a></li>
</ul>
</li>
<li class="dropdown">
@@ -542,11 +543,14 @@ Connection conn = DriverManager.getConne
<li >
<a href="server.html" title="Query Server">Query Server</a>
</li>
+ <li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
<li class="active">
<a href="#" 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/transactions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/transactions.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/transactions.html (original)
+++ phoenix/site/publish/transactions.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">
@@ -440,10 +441,13 @@ DELETE FROM my_other_table WHERE k=2;
<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/tuning.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/tuning.html (original)
+++ phoenix/site/publish/tuning.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">
@@ -614,10 +615,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/tuning_guide.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning_guide.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/tuning_guide.html (original)
+++ phoenix/site/publish/tuning_guide.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">
@@ -612,10 +613,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/udf.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/udf.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/udf.html (original)
+++ phoenix/site/publish/udf.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">
@@ -493,10 +494,13 @@ Connection conn = DriverManager.getConne
<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/update_statistics.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/update_statistics.html (original)
+++ phoenix/site/publish/update_statistics.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">
@@ -414,10 +415,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/upgrading.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/upgrading.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/upgrading.html (original)
+++ phoenix/site/publish/upgrading.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">
@@ -375,10 +376,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/views.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.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">
@@ -404,10 +405,13 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<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/who_is_using.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/who_is_using.html?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/publish/who_is_using.html (original)
+++ phoenix/site/publish/who_is_using.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">
@@ -457,10 +458,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/source/src/site/markdown/cursors.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/cursors.md?rev=1808487&view=auto
==============================================================================
--- phoenix/site/source/src/site/markdown/cursors.md (added)
+++ phoenix/site/source/src/site/markdown/cursors.md Fri Sep 15 22:10:25 2017
@@ -0,0 +1,39 @@
+# Cursor
+
+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.
+
+1. Define cursor for a query using DECLARE statement
+
+ ```
+ PreparedStatement statement = conn.prepareStatement("DECLARE empCursor CURSOR FOR SELECT * FROM EMP_TABLE");
+ statement.execute();
+ ```
+
+2. Open the cursor
+
+ ```
+ statement = con.prepareStatement("OPEN empCursor");
+ statement.execute();
+ ```
+
+3. Fetch subset of rows to work with
+
+ ```
+ statement = con.prepareStatement("FETCH NEXT 10 ROWS FROM empCursor");
+ ResultSet rset = statement.execute();
+ ```
+
+4. Iterate through the subset of rows and process them as required
+
+ ```
+ while (rset.next != null){
+ ...
+ }
+ ```
+
+5. Fetch additional set of rows to process and finally close the cursor when done
+
+ ```
+ statement = con.prepareStatement(âCLOSE empCursor");
+ statement.execute();
+ ```
Modified: phoenix/site/source/src/site/markdown/secondary_indexing.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/secondary_indexing.md?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/secondary_indexing.md (original)
+++ phoenix/site/source/src/site/markdown/secondary_indexing.md Fri Sep 15 22:10:25 2017
@@ -311,6 +311,35 @@ We track secondary index performance via
That said, we have seen secondary indexing (both immutable and mutable) go as quickly as < 2x the regular write path on a small, (3 node) desktop-based cluster. This is actually pretty reasonable as we have to write to multiple tables as well as build the index update.
+## Index Scrutiny Tool
+With Phoenix 4.12, there is now a tool to run a MapReduce job to verify that an index table is valid against its data table. The only way to find orphaned rows in either table is to scan over all rows in the table and do a lookup in the other table for the corresponding row. For that reason, the tool can run with either the data or index table as the "source" table, and the other as the "target" table. The tool writes all invalid rows it finds either to file or to an output table PHOENIX\_INDEX\_SCRUTINY. An invalid row is a source row that either has no corresponding row in the target table, or has an incorrect value in the target table (i.e. covered column value).
+
+The tool has job counters that track its status. `VALID_ROW_COUNT`, `INVALID_ROW_COUNT`, `BAD_COVERED_COL_VAL_COUNT`. Note that invalid rows - bad col val rows = number of orphaned rows. These counters are written to the table PHOENIX\_INDEX\_SCRUTINY\_METADATA, along with other job metadata.
+
+The Index Scrutiny Tool can be launched via the `hbase` command (in hbase/bin) as follows:
+
+ hbase org.apache.phoenix.mapreduce.index.IndexScrutinyTool -dt my_table -it my_index -o
+It can also be run from Hadoop using either the phoenix-core or phoenix-server jar as follows:
+
+ HADOOP_CLASSPATH=$(hbase mapredcp) hadoop jar phoenix-<version>-server.jar org.apache.phoenix.mapreduce.index.IndexScrutinyTool -dt my_table -it my_index -o
+By default two mapreduce jobs are launched, one with the data table as the source table and one with the index table as the source table.
+
+The following parameters can be used with the Index Scrutiny Tool:
+
+| *Parameter* | *Description* |
+|----------------------------|-----------------------------------------------|
+|-dt,--data-table |Data table name (mandatory) |
+|-it,--index-table |Index table name (mandatory) |
+|-s,--schema |Phoenix schema name (optional) |
+|-src,--source |DATA\_TABLE\_SOURCE, INDEX\_TABLE\_SOURCE, or BOTH. Defaults to BOTH |
+|-o,--output |Whether to output invalid rows. Off by default |
+|-of,--output-format |TABLE or FILE output format. Defaults to TABLE |
+|-om,--output-max |Maximum number of invalid rows to output per mapper. Defaults to 1M |
+|-op,--output-path |For FILE output format, the HDFS directory where files are written
+|-t,--time |Timestamp in millis at which to run the scrutiny. This is important so that incoming writes don't throw off the scrutiny. Defaults to current time minus 60 seconds |
+|-b,--batch-size |Number of rows to compare at a time |
+
+
## Resources
There have been several presentations given on how secondary indexing works in Phoenix that have a more in-depth look at how indexing works (with pretty pictures!):
Modified: phoenix/site/source/src/site/site.xml
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/site.xml?rev=1808487&r1=1808486&r2=1808487&view=diff
==============================================================================
--- phoenix/site/source/src/site/site.xml (original)
+++ phoenix/site/source/src/site/site.xml Fri Sep 15 22:10:25 2017
@@ -118,8 +118,9 @@
<item href="http:divider" name=""/>
<item href="bulk_dataload.html" name="Bulk Loading"/>
<item href="server.html" name="Query Server"/>
- <item href="tracing.html" name="Tracing"/>
<item href="metrics.html" name="Metrics"/>
+ <item href="tracing.html" name="Tracing"/>
+ <item href="cursors.html" name="Cursor"/>
</menu>
<menu name="Reference">
<item href="language/index.html" name="Grammar"/>