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 2014/10/20 10:07:43 UTC
svn commit: r1633072 [2/2] - in /phoenix: phoenix-docs/src/docsrc/help/
phoenix-docs/src/main/org/h2/ phoenix-docs/src/main/org/h2/jdbc/
phoenix-docs/src/main/org/h2/jdbcx/ phoenix-docs/src/main/org/h2/tools/
phoenix-docs/src/tools/org/h2/build/doc/ si...
Added: phoenix/site/publish/update_statistics.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1633072&view=auto
==============================================================================
--- phoenix/site/publish/update_statistics.html (added)
+++ phoenix/site/publish/update_statistics.html Mon Oct 20 08:07:42 2014
@@ -0,0 +1,361 @@
+
+<!DOCTYPE html>
+<!--
+ Generated by Apache Maven Doxia at 2014-10-20
+ Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
+-->
+<html xml:lang="en" lang="en">
+
+ <head>
+ <meta charset="UTF-8" />
+ <title>Statistics Collection | Apache Phoenix</title>
+ <meta name="viewport" content="width=device-width, initial-scale=1.0" />
+ <meta name="description" content="" />
+ <meta http-equiv="content-language" content="en" />
+
+ <link href="http://netdna.bootstrapcdn.com/bootswatch/2.3.2/united/bootstrap.min.css" rel="stylesheet" />
+ <link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/css/bootstrap-responsive.min.css" rel="stylesheet" />
+ <link href="./css/bootswatch.css" rel="stylesheet" />
+ <link href="./css/reflow-skin.css" rel="stylesheet" />
+
+ <link href="http://yandex.st/highlightjs/7.5/styles/default.min.css" rel="stylesheet" />
+
+ <link href="./css/lightbox.css" rel="stylesheet" />
+
+ <link href="./css/site.css" rel="stylesheet" />
+ <link href="./css/print.css" rel="stylesheet" media="print" />
+
+ <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
+ <!--[if lt IE 9]>
+ <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
+ <![endif]-->
+
+
+
+ </head>
+
+ <body class="page-update_statistics project-phoenix-site" data-spy="scroll" data-offset="60" data-target="#toc-scroll-target">
+
+ <div class="navbar navbar-fixed-top">
+ <div class="navbar-inner">
+ <div class="container">
+ <a class="btn btn-navbar" data-toggle="collapse" data-target="#top-nav-collapse">
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ </a>
+ <a class="brand" href="index.html"><div class="xtoplogo"></div></a>
+ <div class="nav-collapse collapse" id="top-nav-collapse">
+ <ul class="nav pull-right">
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="index.html" title="Overview">Overview</a></li>
+ <li ><a href="recent.html" title="New Features">New Features</a></li>
+ <li ><a href="roadmap.html" title="Roadmap">Roadmap</a></li>
+ <li ><a href="performance.html" title="Performance">Performance</a></li>
+ <li ><a href="team.html" title="Team">Team</a></li>
+ <li ><a href="contributing.html" title="Contributing">Contributing</a></li>
+ <li ><a href="resources.html" title="Resources">Resources</a></li>
+ <li ><a href="mailing_list.html" title="Mailing Lists">Mailing Lists</a></li>
+ <li ><a href="source.html" title="Source Repository">Source Repository</a></li>
+ <li ><a href="issues.html" title="Issue Tracking">Issue Tracking</a></li>
+ <li ><a href="download.html" title="Download">Download</a></li>
+ <li class="divider"/>
+ <li ><a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a></li>
+ <li ><a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a></li>
+ <li ><a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a></li>
+ <li ><a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Using <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="faq.html" title="F.A.Q.">F.A.Q.</a></li>
+ <li ><a href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a></li>
+ <li ><a href="building.html" title="Building">Building</a></li>
+ <li ><a href="tuning.html" title="Tuning">Tuning</a></li>
+ <li ><a href="upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a></li>
+ <li class="divider"/>
+ <li ><a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li>
+ <li ><a href="joins.html" title="Joins">Joins</a></li>
+ <li ><a href="views.html" title="Views">Views</a></li>
+ <li ><a href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li>
+ <li ><a href="sequences.html" title="Sequences">Sequences</a></li>
+ <li ><a href="array_type.html" title="ARRAY type">ARRAY type</a></li>
+ <li ><a href="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="paged.html" title="Paged Queries">Paged Queries</a></li>
+ <li ><a href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
+ <li ><a href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
+ <li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li class="active"><a href="" title="Statistics Collection">Statistics Collection</a></li>
+ <li class="divider"/>
+ <li ><a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
+ <li ><a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
+ <li ><a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Reference <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="language/index.html" title="Grammar">Grammar</a></li>
+ <li ><a href="language/functions.html" title="Functions">Functions</a></li>
+ <li ><a href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
+ </ul>
+ </li>
+ </ul>
+ </div><!--/.nav-collapse -->
+ </div>
+ </div>
+ </div>
+
+ <div class="container">
+
+ <!-- Masthead
+ ================================================== -->
+
+ <header>
+ </header>
+
+ <div class="main-body">
+ <div class="row">
+ <div class="span12">
+ <div class="body-content">
+<div class="page-header">
+ <h1>Statistics Collection</h1>
+</div>
+<p>The UPDATE STATISTICS command updates the statistics collected on a table, to improve query performance. This command collects a set of keys per region per column family that are equal byte distanced from each other. These collected keys are called <i>guideposts</i> and they act as <i>hints/guides</i> to improve the parallelization of queries on a given target region.</p>
+<p>The statistics are also collected during major compaction and when ever a region split happens so manually running the command may not be necessary.</p>
+<div class="section">
+ <h2 id="Examples">Examples</h2>
+ <p>For a given table <tt>my_table</tt>:</p>
+ <div class="source">
+ <pre>UPDATE STATISTICS <code>my_table</code>
+</pre>
+ </div>
+ <p>The above syntax would collect the statistics for the table my_table and all the index tables, views and view index tables associated with the table my_table.</p>
+ <p>The equivalent of the above syntax is</p>
+ <div class="source">
+ <pre>UPDATE STATISTICS <code>my_table</code> ALL
+</pre>
+ </div>
+ <p>To collect the statistics on the index table alone</p>
+ <div class="source">
+ <pre>UPDATE STATISTICS <code>my_table</code> INDEX
+</pre>
+ </div>
+ <p>To collect the statistics on the table alone</p>
+ <div class="source">
+ <pre>UPDATE STATISTICS <code>my_table</code> COLUMNS
+</pre>
+ </div>
+</div>
+<div class="section">
+ <h2 id="Configurations">Configurations</h2>
+ <p>Some of the configurations associated with the UPDATE STATISTICS command are</p>
+ <ol style="list-style-type: decimal">
+ <li><tt>phoenix.stats.guidepost.width</tt>
+ <ul>
+ <li>A server-side configuration that specifies the absolute byte value that determines the number of bytes between the collected guideposts.</li>
+ </ul></li>
+ <li><tt>phoenix.stats.guidepost.per.region</tt>
+ <ul>
+ <li>Determines the number of guideposts per region. If the configuration âphoenix.stats.guidepost.widthâ is not set then the MAX_FILE_SIZE associated with the table (for which statistics collection is needed) divided by the values set for this configuration will be used for âphoenix.stats.guidepost.widthâ.</li>
+ <li>The default value is 20</li>
+ </ul></li>
+ <li><tt>phoenix.stats.minUpdateFrequency</tt>
+ <ul>
+ <li>Minimum time in milliseconds that must be passed before another UPDATE STATISTICS call be issued once again to collect the statistics again.</li>
+ </ul></li>
+ <li><tt>phoenix.stats.updateFrequency</tt>
+ <ul>
+ <li>Minimum frequency in milliseconds that new statistics will be checked for when pulling over new metadata from the client to the server.</li>
+ </ul></li>
+ </ol>
+</div>
+ </div>
+ </div>
+ </div>
+ </div>
+
+ </div><!-- /container -->
+
+ <!-- Footer
+ ================================================== -->
+ <footer class="well">
+ <div class="container">
+ <div class="row">
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">About</li>
+ <li >
+ <a href="index.html" title="Overview">Overview</a>
+ </li>
+ <li >
+ <a href="recent.html" title="New Features">New Features</a>
+ </li>
+ <li >
+ <a href="roadmap.html" title="Roadmap">Roadmap</a>
+ </li>
+ <li >
+ <a href="performance.html" title="Performance">Performance</a>
+ </li>
+ <li >
+ <a href="team.html" title="Team">Team</a>
+ </li>
+ <li >
+ <a href="contributing.html" title="Contributing">Contributing</a>
+ </li>
+ <li >
+ <a href="resources.html" title="Resources">Resources</a>
+ </li>
+ <li >
+ <a href="mailing_list.html" title="Mailing Lists">Mailing Lists</a>
+ </li>
+ <li >
+ <a href="source.html" title="Source Repository">Source Repository</a>
+ </li>
+ <li >
+ <a href="issues.html" title="Issue Tracking">Issue Tracking</a>
+ </li>
+ <li >
+ <a href="download.html" title="Download">Download</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a>
+ </li>
+ <li >
+ <a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a>
+ </li>
+ <li >
+ <a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a>
+ </li>
+ <li >
+ <a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Using</li>
+ <li >
+ <a href="faq.html" title="F.A.Q.">F.A.Q.</a>
+ </li>
+ <li >
+ <a href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a>
+ </li>
+ <li >
+ <a href="building.html" title="Building">Building</a>
+ </li>
+ <li >
+ <a href="tuning.html" title="Tuning">Tuning</a>
+ </li>
+ <li >
+ <a href="upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
+ </li>
+ <li >
+ <a href="joins.html" title="Joins">Joins</a>
+ </li>
+ <li >
+ <a href="views.html" title="Views">Views</a>
+ </li>
+ <li >
+ <a href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a>
+ </li>
+ <li >
+ <a href="sequences.html" title="Sequences">Sequences</a>
+ </li>
+ <li >
+ <a href="array_type.html" title="ARRAY type">ARRAY type</a>
+ </li>
+ <li >
+ <a href="salted.html" title="Salted Tables">Salted Tables</a>
+ </li>
+ <li >
+ <a href="paged.html" title="Paged Queries">Paged Queries</a>
+ </li>
+ <li >
+ <a href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a>
+ </li>
+ <li >
+ <a href="skip_scan.html" title="Skip Scan">Skip Scan</a>
+ </li>
+ <li >
+ <a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
+ </li>
+ <li >
+ <a href="tracing.html" title="Tracing">Tracing</a>
+ </li>
+ <li class="active">
+ <a href="#" title="Statistics Collection">Statistics Collection</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a>
+ </li>
+ <li >
+ <a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a>
+ </li>
+ <li >
+ <a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Reference</li>
+ <li >
+ <a href="language/index.html" title="Grammar">Grammar</a>
+ </li>
+ <li >
+ <a href="language/functions.html" title="Functions">Functions</a>
+ </li>
+ <li >
+ <a href="language/datatypes.html" title="Datatypes">Datatypes</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-description">
+ <form action="https://www.google.com/search" method="get"><input value="phoenix.apache.org" name="sitesearch" type="hidden"><input placeholder="Search the site…" required="required" style="width:170px;" size="18" name="q" id="query" type="search"></form>
+ </div>
+ </div>
+ </div>
+ </footer>
+
+ <div class="container subfooter">
+ <div class="row">
+ <div class="span12">
+ <p class="pull-right"><a href="#">Back to top</a></p>
+ <p class="copyright">Copyright ©2014 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
+ </div>
+ </div>
+ </div>
+
+ <!-- Le javascript
+ ================================================== -->
+ <!-- Placed at the end of the document so the pages load faster -->
+ <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
+
+ <script src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script>
+ <script src="./js/lightbox.js"></script>
+ <script src="./js/jquery.smooth-scroll.min.js"></script>
+ <!-- back button support for smooth scroll -->
+ <script src="./js/jquery.ba-bbq.min.js"></script>
+ <script src="http://yandex.st/highlightjs/7.5/highlight.min.js"></script>
+
+ <script src="./js/reflow-skin.js"></script>
+
+ </body>
+</html>
Modified: phoenix/site/publish/upgrade_from_2_2.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/upgrade_from_2_2.html?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/publish/upgrade_from_2_2.html (original)
+++ phoenix/site/publish/upgrade_from_2_2.html Mon Oct 20 08:07:42 2014
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2014-09-04
+ Generated by Apache Maven Doxia at 2014-10-20
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -89,6 +89,7 @@
<li ><a href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a></li>
<li class="divider"/>
<li ><a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
<li ><a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
@@ -278,6 +279,9 @@
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
+ <a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a>
+ </li>
+ <li >
<a href="http:divider" title=""></a>
</li>
<li >
Modified: phoenix/site/publish/views.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Mon Oct 20 08:07:42 2014
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2014-09-04
+ Generated by Apache Maven Doxia at 2014-10-20
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -89,6 +89,7 @@
<li ><a href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
<li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
<li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a></li>
<li class="divider"/>
<li ><a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
<li ><a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
@@ -302,6 +303,9 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<a href="tracing.html" title="Tracing">Tracing</a>
</li>
<li >
+ <a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a>
+ </li>
+ <li >
<a href="http:divider" title=""></a>
</li>
<li >
Modified: phoenix/site/source/src/site/markdown/recent.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/recent.md?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/recent.md (original)
+++ phoenix/site/source/src/site/markdown/recent.md Mon Oct 20 08:07:42 2014
@@ -1,12 +1,15 @@
# New Features
As items are implemented from our road map, they are moved here to track the progress we've made:
-1. **[Collect Statistics](update_statistics.html)**. Collects the statistics for a table to improve query parallelization.** Available in our 3.2/4.2 release**
+
+1. **[Statistics Collection](update_statistics.html)**. Collects the statistics for a table to improve query parallelization. **Available in our 3.2/4.2 release**
+2. **[Join Improvements](joins.html)**. Improve existing hash join implementation.
+ * **[Optimize foreign key joins](https://issues.apache.org/jira/browse/PHOENIX-852)**. Optimize foreign key joins by leveraging our skip scan filter. **Available in our 3.2/4.2 release**
+ * **[Semi/anti joins](https://issues.apache.org/jira/browse/PHOENIX-167)**. Support semi/anti sub queries through the standard [NOT] IN and [NOT] EXISTS keywords. **Available in our 3.2/4.2 release**
1. **[Tracing](tracing.html)**. Allows visibility into the various steps of an <code>UPSERT</code> or <code>SELECT</code> statement along with how long each step took across all the machines in your cluster. **Available in our 4.1 release**
2. **[Local Indexing](secondary_indexing.html#Local_Indexing)**. A new, complementary indexing stragegry for _write heavy_, _space constrained_ use cases. With local indexes, index and table data co-reside on same server so no network overhead occurs during writes. Local indexes can be used even when the query isnât fully covered (i.e. Phoenix automatically retrieve the columns not in the index through point gets against the data table). **Available in our 4.1 release**
8. **[Derived Tables](https://issues.apache.org/jira/browse/PHOENIX-136)**. Allows a <code>SELECT</code> clause to be used in the FROM clause to define a _derived_ table (including join queries). **Available in our 3.1/4.1 release**
9. **[Apache Pig Loader](pig_integration.html#Pig_Loader)** . Support for a Pig loader to leverage the performance of Phoenix when processing data through Pig. **Available in our 3.1/4.1 release**
-1. **[Joins](joins.html)**. Join support through hash joins (where one side of the query is small enough to fit into memory). **Available in our 3.0/4.0 release**
2. **[Views](views.html)**. Allows the creation of multiple tables using the same physical HBase table. **Available in our 3.0/4.0 release**
3. **[Multi-tenancy](multi-tenancy.html)**. Allows independent views to be created by different tenants on a per-connection basis that all share the same physical HBase table. **Available in our 3.0/4.0 release**
2. **[Sequences](sequences.html)**. Support for CREATE/DROP SEQUENCE, NEXT VALUE FOR, and CURRENT VALUE FOR has been implemented. **Available in our 3.0/4.0 release**
Modified: phoenix/site/source/src/site/markdown/roadmap.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/roadmap.md?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/roadmap.md (original)
+++ phoenix/site/source/src/site/markdown/roadmap.md Mon Oct 20 08:07:42 2014
@@ -4,12 +4,10 @@ Our roadmap is driven by our user commun
1. **[Transaction Support](https://issues.apache.org/jira/browse/PHOENIX-400)**. Support transactions by integrating with an open source solution like [Tephra](https://github.com/continuuity/tephra), [Themis](https://github.com/XiaoMi/themis), or some other similar option.
1. **[Join Improvements](https://issues.apache.org/jira/browse/PHOENIX-1167)**. Enhance our join capabilities in a variety of ways:<br/>
- * **[Optimize foreign key joins](https://issues.apache.org/jira/browse/PHOENIX-852)**. Optimize foreign key joins by leveraging our skip scan filter.
* **[Correlated sub-queries](https://issues.apache.org/jira/browse/PHOENIX-1168)**. Support correlated sub queries on top of hash joins.
- * **[Semi/anti joins](https://issues.apache.org/jira/browse/PHOENIX-167)**. Support semi/anti sub queries through the standard [NOT] IN and [NOT] EXISTS keywords.
* **[Many-to-many joins](https://issues.apache.org/jira/browse/PHOENIX-1179)**. Support joins where both sides are too large to fit into memory.
* **[Inlined parent/child joins](https://issues.apache.org/jira/browse/PHOENIX-150)**. Optimize parent/child joins by storing child rows inside of a parent row, forming the column qualifier through a known prefix plus the child row primary key.
-15. **[Cost-based Query Optimization]((https://issues.apache.org/jira/browse/PHOENIX-1177))**. With [statistics collection](update_statistics.html) in place, we would like to enable further query optmizations based on the size and cardinality of the data.
+15. **[Cost-based Query Optimization]((https://issues.apache.org/jira/browse/PHOENIX-1177))**. Enhance existing [statistics collection](update_statistics.html) by enabling further query optmizations based on the size and cardinality of the data.
* **[Generate histograms](https://issues.apache.org/jira/browse/PHOENIX-1178)** to drive query optimization decisions such as secondary index usage and join ordering based on cardinalities to produce the most efficient query plan.
9. **[Functional Indexes](https://issues.apache.org/jira/browse/PHOENIX-514)**. Enables an index to contain the evaluation of an expression as opposed to just a column value and use the index when a statement contains this expression.
6. **Type Enhancements**. Additional work includes support for [DEFAULT declaration](https://issues.apache.org/jira/browse/PHOENIX-476) when creating a table, and for [STRUCT](https://issues.apache.org/jira/browse/PHOENIX-477) and [JSON](https://issues.apache.org/jira/browse/PHOENIX-628) data types.
Modified: phoenix/site/source/src/site/markdown/update_statistics.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/update_statistics.md?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/update_statistics.md (original)
+++ phoenix/site/source/src/site/markdown/update_statistics.md Mon Oct 20 08:07:42 2014
@@ -12,45 +12,38 @@ may not be necessary.
For a given table <code>my_table</code>:
- UPDATE STATISTICS <code>my_table</code>
+ UPDATE STATISTICS <code>my_table</code>
The above syntax would collect the statistics for the table my_table and all the index tables, views and view index tables associated
with the table my_table.
The equivalent of the above syntax is
- UPDATE STATISTICS <code>my_table</code> ALL
+ UPDATE STATISTICS <code>my_table</code> ALL
To collect the statistics on the index table alone
- UPDATE STATISTICS <code>my_table</code> INDEX
+ UPDATE STATISTICS <code>my_table</code> INDEX
To collect the statistics on the table alone
- UPDATE STATISTICS <code>my_table</code> COLUMNS
+ UPDATE STATISTICS <code>my_table</code> COLUMNS
## Configurations
Some of the configurations associated with the UPDATE STATISTICS command are
1. <code>phoenix.stats.guidepost.width</code>
-
* A server-side configuration that specifies the absolute byte value that determines the number of bytes between the collected
guideposts.
-
2. <code>phoenix.stats.guidepost.per.region</code>
-
- * Determines the number of guideposts per region. If the configuration 'phoenix.stats.guidepost.width' is not set then the
+ * Determines the number of guideposts per region. If the configuration 'phoenix.stats.guidepost.width' is not set then the
MAX_FILE_SIZE associated with the table (for which statistics collection is needed) divided by the values set for this
configuration will be used for 'phoenix.stats.guidepost.width'.
- * The default value is 20
-
+ * The default value is 20
3. <code>phoenix.stats.minUpdateFrequency</code>
-
- * Minimum time in milliseconds that must be passed before another UPDATE STATISTICS call be issued once again to collect the
+ * Minimum time in milliseconds that must be passed before another UPDATE STATISTICS call be issued once again to collect the
statistics again.
-
4. <code>phoenix.stats.updateFrequency</code>
-
- * Minimum frequency in milliseconds that new statistics will be checked for when pulling over new metadata from the client to the
+ * Minimum frequency in milliseconds that new statistics will be checked for when pulling over new metadata from the client to the
server.
Modified: phoenix/site/source/src/site/site.xml
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/site.xml?rev=1633072&r1=1633071&r2=1633072&view=diff
==============================================================================
--- phoenix/site/source/src/site/site.xml (original)
+++ phoenix/site/source/src/site/site.xml Mon Oct 20 08:07:42 2014
@@ -90,7 +90,7 @@
<item href="skip_scan.html" name="Skip Scan"/>
<item href="bulk_dataload.html" name="Bulk Loading"/>
<item href="tracing.html" name="Tracing"/>
- <item href="update_statistcs.html" name="Statistics Collection"/>
+ <item href="update_statistics.html" name="Statistics Collection"/>
<item href="http:divider" name=""/>
<item href="phoenix_on_emr.html" name="Amazon EMR Support"/>
<item href="flume.html" name="Apache Flume Plugin"/>