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 2018/02/06 19:36:23 UTC
svn commit: r1823379 [2/2] - in /phoenix/site: publish/ publish/language/
source/src/site/ source/src/site/markdown/
Modified: phoenix/site/publish/rowtimestamp.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/rowtimestamp.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/rowtimestamp.html (original)
+++ phoenix/site/publish/rowtimestamp.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -272,6 +273,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -423,7 +427,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/salted.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/salted.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/salted.html (original)
+++ phoenix/site/publish/salted.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -280,6 +281,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -431,7 +435,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/secondary_indexing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/secondary_indexing.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/secondary_indexing.html (original)
+++ phoenix/site/publish/secondary_indexing.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -643,6 +644,9 @@ CREATE LOCAL INDEX my_index ON my_table
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -794,7 +798,7 @@ CREATE LOCAL INDEX my_index ON my_table
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/sequences.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/sequences.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/sequences.html (original)
+++ phoenix/site/publish/sequences.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -311,6 +312,9 @@ VALUES( NEXT VALUE FOR my_schema.my_sequ
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -462,7 +466,7 @@ VALUES( NEXT VALUE FOR my_schema.my_sequ
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/server.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/server.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/server.html (original)
+++ phoenix/site/publish/server.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -559,6 +560,9 @@ log4j.logger.org.eclipse.jetty.server=IN
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -710,7 +714,7 @@ log4j.logger.org.eclipse.jetty.server=IN
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/skip_scan.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/skip_scan.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/skip_scan.html (original)
+++ phoenix/site/publish/skip_scan.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -269,6 +270,9 @@ AND KEY2 IN (1, 2)
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -420,7 +424,7 @@ AND KEY2 IN (1, 2)
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/source.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/source.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/source.html (original)
+++ phoenix/site/publish/source.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -275,6 +276,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -426,7 +430,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/subqueries.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/subqueries.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/subqueries.html (original)
+++ phoenix/site/publish/subqueries.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -413,6 +414,9 @@ ORDER BY count(*) DESC;
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -564,7 +568,7 @@ ORDER BY count(*) DESC;
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/tablesample.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tablesample.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/tablesample.html (original)
+++ phoenix/site/publish/tablesample.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -314,6 +315,9 @@ select count( * ) from (select NAME from
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -465,7 +469,7 @@ select count( * ) from (select NAME from
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/team.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/team.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/team.html (original)
+++ phoenix/site/publish/team.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2018-01-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -480,6 +481,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
Modified: phoenix/site/publish/tracing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tracing.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/tracing.html (original)
+++ phoenix/site/publish/tracing.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -451,6 +452,9 @@ Connection conn = DriverManager.getConne
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -602,7 +606,7 @@ Connection conn = DriverManager.getConne
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/transactions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/transactions.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/transactions.html (original)
+++ phoenix/site/publish/transactions.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -348,6 +349,9 @@ DELETE FROM my_other_table WHERE k=2;
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -499,7 +503,7 @@ DELETE FROM my_other_table WHERE k=2;
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/tuning.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/tuning.html (original)
+++ phoenix/site/publish/tuning.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</a></li>
<li class="active"><a href="" 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>
@@ -521,6 +522,9 @@
<li >
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
+ <li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
<li class="active">
<a href="#" title="Configuration">Configuration</a>
</li>
@@ -673,7 +677,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/tuning_guide.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning_guide.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/tuning_guide.html (original)
+++ phoenix/site/publish/tuning_guide.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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 class="active"><a href="" title="Tuning">Tuning</a></li>
+ <li ><a href="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -164,6 +165,7 @@
<h1>Tuning Guide</h1>
</div>
<p>Tuning Phoenix can be complex, but with a little knowledge of how it works you can make significant changes to the performance of your reads and writes. The most important factor in performance is the design of your schema, especially as it affects the underlying HBase row keys. Look in âGeneral Tipsâ below to find design advice for different anticipated data access patterns. Subsequent sections describe how to use secondary indexes, hints, and explain plans.</p>
+<p><b>Note:</b> Phoenix and HBase work well when your application does point lookups and small range scans. This can be achieved by good primary key design (see below). If you find that your application requires many full table scans, then Phoenix and HBase are likely not the best tool for the job. Instead, look at using other tools that write to HDFS directly using columnar representations such as Parquet.</p>
<h1>Primary Keys</h1>
<p>The underlying row key design is the single most important factor in Phoenix performance, and itâs important to get it right at design time because you cannot change it later without re-writing the data and index tables.</p>
<p>The Phoenix primary keys are concatenated to create the underlying row key in Apache HBase. The columns for the primary key constraint should be chosen and ordered in a way that aligns with the common query patternsâchoose the most frequently queried columns as primary keys. The key that you place in the leading position is the most performant one. For example, if you lead off with a column containing org ID values, it is easy to select all rows pertaining to a specific org. You can add the HBase row timestamp to the primary key to improve scan efficiency by skipping rows outside the queried time range. </p>
@@ -319,13 +321,22 @@
</ul>
<p>See also: <a class="externalLink" href="https://phoenix.apache.org/language/#hint">Hint</a>.</p>
</div>
+ <div class="section">
+ <h3 id="Explain_Plans">Explain Plans</h3>
+ <p>An <tt>EXPLAIN</tt> plan tells you a lot about how a query will be run. To generate an explain plan run <a href="language/index.html#explain">this</a> query and to interpret the plan, see <a href="explainplan.html">this</a> reference.</p>
+ </div>
+ <div class="section">
+ <h3 id="Parallelization">Parallelization</h3>
+ <p>You can improve parallelization with the <a class="externalLink" href="https://phoenix.apache.org/update_statistics.html">UPDATE STATISTICS</a> command. This command subdivides each region by determining keys called <i>guideposts</i> that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans. Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.</p>
+ <p>In Phoenix 4.12, we have added a new configuration <tt>phoenix.use.stats.parallelization</tt> that controls whether statistics should be used for driving parallelization. Note that one can still run stats collection. The information collected is used to surface estimates on number of bytes and rows a query will scan when an EXPLAIN is generated for it. </p>
+ </div>
</div>
<div class="section">
<h2 id="Writing">Writing</h2>
<div class="section">
- <h3 id="Batching_large_numbers_of_records">Batching large numbers of records</h3>
- <p>When using <tt>UPSERT</tt> to write a large number of records, turn off autocommit and batch records. <b>Note:</b> Phoenix uses <tt>commit()</tt> instead of <tt>executeBatch()</tt> to control batch updates.</p>
- <p>Start with a batch size of 1000 and adjust as needed. Hereâs some pseudocode showing one way to commit records in batches:</p>
+ <h3 id="Updating_data_with_UPSERT_VALUES">Updating data with UPSERT VALUES</h3>
+ <p>When using <tt>UPSERT VALUES</tt> to write a large number of records, turn off autocommit and batch records in reasonably small batches (try 100 rows and adjust from there to fine-tune performance).</p>
+ <p><b>Note:</b> With the default fat driver, <tt>executeBatch()</tt> will not provide any benefit. Instead update mutliple rows by executing <tt>UPSERT VALUES</tt> mutliple times and then use <tt>commit()</tt> to submit the batch to the cluster. With the thin driver, however, itâs important to use <tt>executeBatch()</tt> as this will minimize the number of RPCs between the client and query server.</p>
<div class="source">
<pre>try (Connection conn = DriverManager.getConnection(url)) {
conn.setAutoCommit(false);
@@ -346,26 +357,25 @@
<p><b>Note:</b> Because the Phoenix client keeps uncommitted rows in memory, be careful not to set <tt>commitSize</tt> too high.</p>
</div>
<div class="section">
+ <h3 id="Updating_data_with_UPSERT_SELECT">Updating data with UPSERT SELECT</h3>
+ <p>When using <tt>UPSERT SELECT</tt> to write many rows in a single statement, turn on autocommit and the rows will be automatically batched according to the <tt>phoenix.mutate.batchSize</tt>. This will minimize the amount of data returned back to the client and is the most efficient means of updating many rows.</p>
+ </div>
+ <div class="section">
+ <h3 id="Deleting_data">Deleting data</h3>
+ <p>When deleting a large data set, turn on autoCommit before issuing the <tt>DELETE</tt> query so that the client does not need to remember the row keys of all the keys as they are deleted. This prevents the client from buffering the rows affected by the <tt>DELETE</tt> so that Phoenix can delete them directly on the region servers without the expense of returning them to the client.</p>
+ </div>
+ <div class="section">
<h3 id="Reducing_RPC_traffic">Reducing RPC traffic</h3>
<p>To reduce RPC traffic, set the <tt>UPDATE_CACHE_FREQUENCY</tt> (4.7 or above) on your table and indexes when you create them (or issue an <tt>ALTER TABLE</tt>/<tt>INDEX</tt> call. See <a class="externalLink" href="https://phoenix.apache.org/#Altering">https://phoenix.apache.org/#Altering</a>.</p>
</div>
<div class="section">
<h3 id="Using_local_indexes">Using local indexes</h3>
<p>If using 4.8, consider using local indexes to minimize the write time. In this case, the writes for the secondary index will be to the same region server as your base table. This approach does involve a performance hit on the read side, though, so make sure to quantify both write speed improvement and read speed reduction.</p>
+ <h1>Further Tuning</h1>
+ <p>For advice about tuning the underlying HBase and JVM layers, see <a class="externalLink" href="https://hbase.apache.org/book.html#schema.ops">Operational and Performance Configuration Options</a> in the Apache HBase⢠Reference Guide.</p>
</div>
</div>
<div class="section">
- <h2 id="Deleting">Deleting</h2>
- <p>When deleting a large data set, turn on autoCommit before issuing the <tt>DELETE</tt> query so that the client does not need to remember the row keys of all the keys as they are deleted. This prevents the client from buffering the rows affected by the <tt>DELETE</tt> so that Phoenix can delete them directly on the region servers without the expense of returning them to the client.</p>
- <h1>Explain Plans</h1>
- <p>An <tt>EXPLAIN</tt> plan tells you a lot about how a query will be run. To generate explain plan look at this reference: <a class="externalLink" href="http://phoenix.apache.org/language/index.html#explain">http://phoenix.apache.org/language/index.html#explain</a>. For a more detailed explaination on how to interpret the explain plan and further use it for tuning queries go to: <a class="externalLink" href="http://phoenix.apache.org/explainplan.html">http://phoenix.apache.org/explainplan.html</a> </p>
- <h1>Improving parallelization</h1>
- <p>You can improve parallelization with the <a class="externalLink" href="https://phoenix.apache.org/update_statistics.html">UPDATE STATISTICS</a> command. This command subdivides each region by determining keys called <i>guideposts</i> that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans. Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.</p>
- <p>In Phoenix 4.12, we have added a new configuration <tt>phoenix.use.stats.parallelization</tt> that controls whether statistics should be used for driving parallelization. Note that one can still run stats collection. The information collected is used to surface estimates on number of bytes and rows a query will scan when an EXPLAIN is generated for it. </p>
- <h1>Further Tuning</h1>
- <p>For advice about tuning the underlying HBase and JVM layers, see <a class="externalLink" href="https://hbase.apache.org/book.html#schema.ops">Operational and Performance Configuration Options</a> in the Apache HBase⢠Reference Guide.</p>
-</div>
-<div class="section">
<h2 id="Special_Cases">Special Cases</h2>
<p>The following sections provide Phoenix-specific additions to the tuning recommendations in the Apache HBase⢠Reference Guide section referenced above. </p>
<div class="section">
@@ -470,6 +480,9 @@
<a href="#" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -621,7 +634,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/udf.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/udf.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/udf.html (original)
+++ phoenix/site/publish/udf.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -401,6 +402,9 @@ Connection conn = DriverManager.getConne
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -552,7 +556,7 @@ Connection conn = DriverManager.getConne
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/update_statistics.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/update_statistics.html (original)
+++ phoenix/site/publish/update_statistics.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -327,6 +328,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -478,7 +482,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/upgrading.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/upgrading.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/upgrading.html (original)
+++ phoenix/site/publish/upgrading.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</a></li>
<li ><a href="tuning.html" title="Configuration">Configuration</a></li>
<li class="active"><a href="" title="Backward Compatibility">Backward Compatibility</a></li>
<li ><a href="release_notes.html" title="Release Notes">Release Notes</a></li>
@@ -283,6 +284,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li class="active">
@@ -434,7 +438,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/views.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -312,6 +313,9 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -463,7 +467,7 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/who_is_using.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/who_is_using.html?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/publish/who_is_using.html (original)
+++ phoenix/site/publish/who_is_using.html Tue Feb 6 19:36:22 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2017-11-30
+ Generated by Apache Maven Doxia at 2018-02-06
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -79,6 +79,7 @@
<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="explainplan.html" title="Explain Plan">Explain Plan</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>
@@ -365,6 +366,9 @@
<a href="tuning_guide.html" title="Tuning">Tuning</a>
</li>
<li >
+ <a href="explainplan.html" title="Explain Plan">Explain Plan</a>
+ </li>
+ <li >
<a href="tuning.html" title="Configuration">Configuration</a>
</li>
<li >
@@ -516,7 +520,7 @@
<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>
+ <p class="copyright">Copyright ©2018 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
</div>
</div>
</div>
Modified: phoenix/site/source/src/site/markdown/explainplan.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/explainplan.md?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/explainplan.md (original)
+++ phoenix/site/source/src/site/markdown/explainplan.md Tue Feb 6 19:36:22 2018
@@ -1,4 +1,4 @@
-# Explain Plans
+# Explain Plan
An `EXPLAIN` plan tells you a lot about how a query will be run:
Modified: phoenix/site/source/src/site/markdown/tuning_guide.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/tuning_guide.md?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/tuning_guide.md (original)
+++ phoenix/site/source/src/site/markdown/tuning_guide.md Tue Feb 6 19:36:22 2018
@@ -2,6 +2,8 @@
Tuning Phoenix can be complex, but with a little knowledge of how it works you can make significant changes to the performance of your reads and writes. The most important factor in performance is the design of your schema, especially as it affects the underlying HBase row keys. Look in âGeneral Tipsâ below to find design advice for different anticipated data access patterns. Subsequent sections describe how to use secondary indexes, hints, and explain plans.
+**Note:** Phoenix and HBase work well when your application does point lookups and small range scans. This can be achieved by good primary key design (see below). If you find that your application requires many full table scans, then Phoenix and HBase are likely not the best tool for the job. Instead, look at using other tools that write to HDFS directly using columnar representations such as Parquet.
+
# Primary Keys
The underlying row key design is the single most important factor in Phoenix performance, and it's important to get it right at design time because you cannot change it later without re-writing the data and index tables.
@@ -175,14 +177,25 @@ Hints let you override default query pro
See also: [Hint](https://phoenix.apache.org/language/#hint).
+### Explain Plans
+
+An `EXPLAIN` plan tells you a lot about how a query will be run. To generate an explain plan run [this](language/index.html#explain) query and to interpret the plan, see [this](explainplan.html) reference.
+
+### Parallelization
+
+You can improve parallelization with the [UPDATE STATISTICS](https://phoenix.apache.org/update_statistics.html) command. This command subdivides each region by determining keys called *guideposts* that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans.
+Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.
+
+In Phoenix 4.12, we have added a new configuration <code>phoenix.use.stats.parallelization</code> that controls whether statistics should be used for driving parallelization. Note that one can still run stats collection. The information collected is used to surface estimates on number of bytes and rows a query will scan when an EXPLAIN is generated for it.
+
## Writing
-### Batching large numbers of records
+### Updating data with UPSERT VALUES
+
+When using `UPSERT VALUES` to write a large number of records, turn off autocommit and batch records in reasonably small batches (try 100 rows and adjust from there to fine-tune performance).
-When using `UPSERT` to write a large number of records, turn off autocommit and batch records.
-**Note:** Phoenix uses `commit()` instead of `executeBatch()` to control batch updates.
+**Note:** With the default fat driver, `executeBatch()` will not provide any benefit. Instead update mutliple rows by executing `UPSERT VALUES` mutliple times and then use `commit()` to submit the batch to the cluster. With the thin driver, however, it's important to use `executeBatch()` as this will minimize the number of RPCs between the client and query server.
-Start with a batch size of 1000 and adjust as needed. Here's some pseudocode showing one way to commit records in batches:
```
try (Connection conn = DriverManager.getConnection(url)) {
@@ -203,29 +216,20 @@ try (Connection conn = DriverManager.get
**Note:** Because the Phoenix client keeps uncommitted rows in memory, be careful not to set `commitSize` too high.
-### Reducing RPC traffic
-
-To reduce RPC traffic, set the `UPDATE_CACHE_FREQUENCY` (4.7 or above) on your table and indexes when you create them (or issue an `ALTER TABLE`/`INDEX` call. See https://phoenix.apache.org/#Altering.
-
-### Using local indexes
-
-If using 4.8, consider using local indexes to minimize the write time. In this case, the writes for the secondary index will be to the same region server as your base table. This approach does involve a performance hit on the read side, though, so make sure to quantify both write speed improvement and read speed reduction.
+### Updating data with UPSERT SELECT
+When using `UPSERT SELECT` to write many rows in a single statement, turn on autocommit and the rows will be automatically batched according to the `phoenix.mutate.batchSize`. This will minimize the amount of data returned back to the client and is the most efficient means of updating many rows.
-## Deleting
+### Deleting data
When deleting a large data set, turn on autoCommit before issuing the `DELETE` query so that the client does not need to remember the row keys of all the keys as they are deleted. This prevents the client from buffering the rows affected by the `DELETE` so that Phoenix can delete them directly on the region servers without the expense of returning them to the client.
-# Explain Plans
-
-An `EXPLAIN` plan tells you a lot about how a query will be run. To generate explain plan look at this reference: http://phoenix.apache.org/language/index.html#explain. For a more detailed explaination on how to interpret the explain plan and further use it for tuning queries go to: http://phoenix.apache.org/explainplan.html
-
+### Reducing RPC traffic
-# Improving parallelization
+To reduce RPC traffic, set the `UPDATE_CACHE_FREQUENCY` (4.7 or above) on your table and indexes when you create them (or issue an `ALTER TABLE`/`INDEX` call. See https://phoenix.apache.org/#Altering.
-You can improve parallelization with the [UPDATE STATISTICS](https://phoenix.apache.org/update_statistics.html) command. This command subdivides each region by determining keys called *guideposts* that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans.
-Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.
+### Using local indexes
-In Phoenix 4.12, we have added a new configuration <code>phoenix.use.stats.parallelization</code> that controls whether statistics should be used for driving parallelization. Note that one can still run stats collection. The information collected is used to surface estimates on number of bytes and rows a query will scan when an EXPLAIN is generated for it.
+If using 4.8, consider using local indexes to minimize the write time. In this case, the writes for the secondary index will be to the same region server as your base table. This approach does involve a performance hit on the read side, though, so make sure to quantify both write speed improvement and read speed reduction.
# Further Tuning
Modified: phoenix/site/source/src/site/site.xml
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/site.xml?rev=1823379&r1=1823378&r2=1823379&view=diff
==============================================================================
--- phoenix/site/source/src/site/site.xml (original)
+++ phoenix/site/source/src/site/site.xml Tue Feb 6 19:36:22 2018
@@ -81,6 +81,7 @@
<item href="Phoenix-in-15-minutes-or-less.html" name="Quick Start"/>
<item href="building.html" name="Building"/>
<item href="tuning_guide.html" name="Tuning"/>
+ <item href="explainplan.html" name="Explain Plan"/>
<item href="tuning.html" name="Configuration"/>
<item href="upgrading.html" name="Backward Compatibility"/>
<item href="release_notes.html" name="Release Notes"/>