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 2016/08/19 17:24:51 UTC
svn commit: r1756947 - in /phoenix: phoenix-docs/src/docsrc/help/
phoenix-docs/src/tools/org/h2/build/doc/ site/publish/
site/publish/language/ site/source/src/site/markdown/
Author: jamestaylor
Date: Fri Aug 19 17:24:50 2016
New Revision: 1756947
URL: http://svn.apache.org/viewvc?rev=1756947&view=rev
Log:
Update docs based on 4.8 and/or missing information
Modified:
phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt
phoenix/site/publish/building_website.html
phoenix/site/publish/download.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/recent.html
phoenix/site/publish/roadmap.html
phoenix/site/publish/views.html
phoenix/site/source/src/site/markdown/building_website.md
phoenix/site/source/src/site/markdown/download.md
phoenix/site/source/src/site/markdown/recent.md
phoenix/site/source/src/site/markdown/roadmap.md
phoenix/site/source/src/site/markdown/views.md
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
URL: http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Fri Aug 19 17:24:50 2016
@@ -414,6 +414,7 @@ parsing is not done on hints. If hints a
","
SKIP_SCAN,NO_INDEX
+USE_SORT_MERGE_JOIN
NO_CACHE
INDEX(employee emp_name_idx emp_start_date_idx)
SMALL
@@ -502,13 +503,22 @@ NO_SEEK_TO_COLUMN
"
"Other Grammar","Join Hint","
-NO_STAR_JOIN
+USE_SORT_MERGE_JOIN | NO_STAR_JOIN | NO_CHILD_PARENT_JOIN_OPTIMIZATION
","
+Use the USE_SORT_MERGE_JOIN hint to force the optimizer to use a sort merge join instead of a
+broadcast hash join when both sides of the join are bigger than will fit in the server-side memory.
+Currently the optimizer will not make this determination itself, so this hint is required to override
+the default behavior of using a hash join.
+
Use the NO_STAR_JOIN hint to prevent the optimizer from using the star join query to broadcast
the results of the querying one common table to all region servers. This is useful when the
results of the querying the one common table is too large and would likely be substantially
filtered when joined against one or more of the other joined tables.
+Use the NO_CHILD_PARENT_JOIN_OPTIMIZATION hint to prevent the optimizer from doing point lookups
+between a child table (such as a secondary index) and a parent table (such as the data table)
+for a correlated subquery.
+
","
NO_STAR_JOIN
"
Modified: phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt
URL: http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt (original)
+++ phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt Fri Aug 19 17:24:50 2016
@@ -729,4 +729,4 @@ rpc doled paranthesis reaching satisfy c
guideposts collects ilike rhs uniformly ttl reviewer ranking earth
hdfs myjar myincrement defaultvalue defualtvalue mypackage raised logarithm euler cbrt
transitioned overriden removal serially parallelized opposed frequency namely tranactional istransactional
-guidepost compaction
+guidepost compaction determination lookups
Modified: phoenix/site/publish/building_website.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-11
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -157,7 +157,8 @@
</pre>
</div>
<ol style="list-style-type: decimal">
- <li>Edit/Add source markdown files in <tt>/src/site/markdown</tt> directory</li>
+ <li>Edit/Add source markdown files in <tt>/src/site/markdown</tt> directory.</li>
+ <li>Edit <tt>phoenix-docs/src/docsrc/help/phoenix.csv</tt> to update Reference pages, adding any missing new words to <tt>phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt</tt>, and manually remove <tt>site/publish/language/*.html</tt>.</li>
<li>Run <tt>build.sh</tt> located at root to generate/update html web pages in <tt>site/publish</tt> directory</li>
<li><tt>svn commit</tt> source markdown files and html web pages</li>
</ol>
Modified: phoenix/site/publish/download.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/download.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/download.html (original)
+++ phoenix/site/publish/download.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-11
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -152,7 +152,7 @@
<div class="section">
<div class="section">
<h3 id="Download_Latest_Phoenix_Binary_and_Source_Releases"><a class="externalLink" href="http://www.apache.org/dyn/closer.lua/phoenix/"><u>Download Latest Phoenix Binary and Source Releases</u></a></h3>
- <p>See our installation instructions <a href="installation.html">here</a>, our release notes <a href="release_notes.html">here</a>, and a list of new features <a href="recent.html">here</a></p>
+ <p>See our installation instructions <a href="installation.html">here</a>, our release notes <a href="release_notes.html">here</a>, and a list of fixes new features <a class="externalLink" href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12334393&projectId=12315120">here</a></p>
</div>
</div>
</div>
Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-16
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-16
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-16
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -963,7 +963,7 @@ syntax-end -->
syntax-end -->
<p>An advanced features that overrides default query processing behavior for decisions such as whether to use a range scan versus skip scan and an index versus no index. Note that strict parsing is not done on hints. If hints are misspelled or invalid, they are silently ignored.</p>
<p>Example:</p>
-<p class="notranslate">SKIP_SCAN,NO_INDEX<br />NO_CACHE<br />INDEX(employee emp_name_idx emp_start_date_idx)<br />SMALL</p>
+<p class="notranslate">SKIP_SCAN,NO_INDEX<br />USE_SORT_MERGE_JOIN<br />NO_CACHE<br />INDEX(employee emp_name_idx emp_start_date_idx)<br />SMALL</p>
<h3 id="scan_hint" class="notranslate">Scan Hint</h3>
<!-- railroad-start -->
@@ -1032,14 +1032,14 @@ syntax-end -->
<h3 id="join_hint" class="notranslate">Join Hint</h3>
<!-- railroad-start -->
-<code class="c">NO_STAR_JOIN</code>
+<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">USE_SORT_MERGE_JOIN</code></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c">NO_STAR_JOIN</code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c">NO_CHILD_PARENT_JOIN_OPTIMIZATION</code></td><td class="le"></td></tr></table>
<!-- railroad-end -->
<!-- syntax-start
<pre>
-NO_STAR_JOIN
+USE_SORT_MERGE_JOIN | NO_STAR_JOIN | NO_CHILD_PARENT_JOIN_OPTIMIZATION
</pre>
syntax-end -->
-<p>Use the <code>NO_STAR_JOIN</code> hint to prevent the optimizer from using the star join query to broadcast the results of the querying one common table to all region servers. This is useful when the results of the querying the one common table is too large and would likely be substantially filtered when joined against one or more of the other joined tables.</p>
+<p>Use the <code>USE_SORT_MERGE_JOIN</code> hint to force the optimizer to use a sort merge join instead of a broadcast hash join when both sides of the join are bigger than will fit in the server-side memory. Currently the optimizer will not make this determination itself, so this hint is required to override the default behavior of using a hash join.</p><p>Use the <code>NO_STAR_JOIN</code> hint to prevent the optimizer from using the star join query to broadcast the results of the querying one common table to all region servers. This is useful when the results of the querying the one common table is too large and would likely be substantially filtered when joined against one or more of the other joined tables.</p><p>Use the <code>NO_CHILD_PARENT_JOIN_OPTIMIZATION</code> hint to prevent the optimizer from doing point lookups between a child table (such as a secondary index) and a parent table (such as the data table) for a correlated subquery.</p>
<p>Example:</p>
<p class="notranslate">NO_STAR_JOIN</p>
Modified: phoenix/site/publish/recent.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/recent.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/recent.html (original)
+++ phoenix/site/publish/recent.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-11
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -151,6 +151,10 @@
</div>
<p>As items are implemented from our road map, they are moved here to track the progress we’ve made:</p>
<ol style="list-style-type: decimal">
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1311">Namespace Mapping</a></b>. Maps Phoenix schema to HBase namespace to improve isolation between different schemas. <b>Available in our 4.8 release</b></li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2743">Hive Integration</a></b>. Enables Hive to be used with Phoenix in support of joining huge tables to other huge tables. <b>Available in our 4.8 release</b></li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1734">Local Index Improvements</a></b>. Reworked local index implementation to guarantee colocation of table and index data and use supported HBase APIs for better maintainability. <b>Available in our 4.8 release</b></li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-258">DISTINCT Query Optimization</a></b>. Push seek logic to server for SELECT DISTINCT and COUNT DISTINCT queries over the leading parts of the primary key leading to dramically better performance. <b>Available in our 4.8 release</b></li>
<li><b><a href="transactions.html">Transaction Support</a></b>. Supports transactions by integrating with <a class="externalLink" href="https://github.com/continuuity/tephra">Tephra</a>. <b>Available in our 4.7 release</b></li>
<li><b><a href="rowtimestamp.html">Time series Optimization</a></b>. Optimizes queries against time series data as explained in more detail <a class="externalLink" href="https://blogs.apache.org/phoenix/entry/new_optimization_for_time_series">here</a>. <b>Available in our 4.6 release</b></li>
<li><b><a href="secondary_indexing.html#Asynchronous_Index_Population">Asynchronous Index Population</a></b>. Enables an index to be created asynchronously using a map reduce job. <b>Available in our 4.5 release</b></li>
Modified: phoenix/site/publish/roadmap.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/roadmap.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/roadmap.html (original)
+++ phoenix/site/publish/roadmap.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-11
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -151,9 +151,12 @@
</div>
<p>Our roadmap is driven by our user community. Below, in prioritized order, is the current plan for Phoenix:</p>
<ol style="list-style-type: decimal">
- <li><b><a class="externalLink" href="https://calcite.incubator.apache.org/">Apache Calcite</a> Adapter</b>. Create a Phoenix adapter for Calcite to increase the breadth of our SQL support, plug into a rich cost-based optimizer framework, and enable potential interop with other adapters. <b>See our <a class="externalLink" href="https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/calcite">calcite branch</a> to try this and track our progress.</b></li>
- <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-628">JSON Support</a></b>. Support a JSON data type and implement the standard operators and built-in functions similar to Postgres. <b>See our <a class="externalLink" href="https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/json">json branch</a> to try this and track our progress.</b></li>
- <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1121">Monitoring and Management Improvements</a></b>. Though we support <a href="tracing.html">tracing</a> now, there’s more work to do to better <i>operationalize</i> Phoenix.</li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-3146">Stress testing</a></b>. Open source and automate the running of stress tests that exercise Phoenix and HBase under high load.</li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-3183">Compatibility testing</a></b>. Open source and automate the running of backward compatibility tests for Phoenix and HBase, including new server versions of Phoenix working with older client versions and unreleased HBase versions compiling with existing Phoenix versions.</li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2909">Atomic update</a></b>. Support an UPDATE statement that runs atomically for a row updates of non transactional tables as a means to expose check-and-put and increment functionality for Phoenix.</li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1598">Column encoding</a></b>. Providing an indirection between the column name and the column qualifier reduces storage space, improves performance and opens the door for enhancements such as renaming columns and dropping columns asynchronously.</li>
+ <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2565">Immutable data packing</a></b>. Since columns in immutable tables are not updated individually, but only inserted together, we can pack all values in a single cell to reduce storage space and improve performance.</li>
+ <li><b><a class="externalLink" href="https://calcite.incubator.apache.org/">Apache Calcite adapter</a></b>. Create a Phoenix adapter for Calcite to increase the breadth of our SQL support, plug into a rich cost-based optimizer framework, and enable potential interop with other adapters. <b>See our <a class="externalLink" href="https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/calcite">calcite branch</a> to try this and track our progress.</b></li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1177">Cost-based Query Optimization</a></b>. Enhance existing <a href="update_statistics.html">statistics collection</a> by enabling further query optmizations based on the size and cardinality of the data.
<ul>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1178">Generate histograms</a></b> to drive query optimization decisions such as secondary index usage and join ordering based on cardinalities to produce the most efficient query plan.</li>
@@ -163,7 +166,7 @@
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1556">Table-stats-guided choice between hash join and sort-merge join</a></b>. Base hash join versus many-to-many decision on how many guideposts will be traversed for RHS table(s).</li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-150">Inlined parent/child joins</a></b>. 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.</li>
</ul></li>
- <li><b><a href="subqueries.html">Subquery</a> Enhancement</b>, which includes support for <b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1388">correlated subqueries in the HAVING clause</a></b> and <b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1392">using subqueries as expressions</a></b>.</li>
+ <li><b><a href="subqueries.html">Subquery enhancements</a></b>, which includes support for <b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1388">correlated subqueries in the HAVING clause</a></b> and <b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1392">using subqueries as expressions</a></b>.</li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-476">DEFAULT declaration</a></b>. When creating a table, we should allow a DEFAULT declaration in our CREATE TABLE statement.</li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-477">STRUCT type</a></b>. Allow declarations of multiple fields of different data types that would be packed into a single cell to reduce the per column storage overhead.</li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-154">OLAP Extensions</a></b>. Support the <tt>WINDOW</tt>, <tt>PARTITION OVER</tt>, <tt>RANK</tt>, and other SQL-92 extensions.</li>
@@ -176,7 +179,6 @@
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-684">Support Cell-level security</a></b>. Surface cell-level security now that HBase supports it.</li>
</ul></li>
<li><b>Schema Evolution</b>. Phoenix supports adding and removing columns through the <a href="language/index.html#alter">ALTER TABLE</a> DDL command, but changing the data type of, or renaming, an existing column is not yet supported.</li>
- <li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-763">Apache Sqoop integration</a></b>. Enable Sqoop to import Phoenix-compliant HBase tables from relational databases.</li>
</ol>
</div>
</div>
Modified: phoenix/site/publish/views.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Fri Aug 19 17:24:50 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-08-11
+ Generated by Apache Maven Doxia at 2016-08-19
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -199,10 +199,9 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<p>Views have the following restrictions:</p>
<ol style="list-style-type: decimal">
<li>An INDEX over a VIEW is only maintained if the updates are made through the VIEW. Updates made through the underlying TABLE or the parent VIEW will not be reflected in the index (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1499">PHOENIX-1499</a>).</li>
- <li>A column of a table may not be dropped once it has VIEWs (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2156">PHOENIX-2156</a>).</li>
<li>A primary key column may not be added to a VIEW when its base table has a primary key constraint that ends with a variable length column (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2157">PHOENIX-2157</a>).</li>
<li>A VIEW may be defined over only a single table through a simple SELECT * query. You may not create a VIEW over multiple, joined tables nor over aggregations (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1505">PHOENIX-1505</a>, <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1506">PHOENIX-1506</a>).</li>
- <li>If a VIEW is derived from another VIEW, the indexes from the base/derived VIEW will not be considered when executing queries (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1367">PHOENIX-1367</a>).</li>
+ <li>If a VIEW is derived from another VIEW, the indexes from the parent VIEW will not be considered when executing queries (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1367">PHOENIX-1367</a>).</li>
<li>All columns must be projected into a VIEW when it’s created (i.e. only CREATE VIEW … AS SELECT * is supported). Note, however, you may drop non primary key columns inherited from the base table in a VIEW after it is created through the ALTER VIEW command. Providing a subset of columns and or expressions in the SELECT clause will be supported in a future release (<a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1507">PHOENIX-1507</a>).</li>
</ol>
</div>
Modified: phoenix/site/source/src/site/markdown/building_website.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/building_website.md?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/building_website.md (original)
+++ phoenix/site/source/src/site/markdown/building_website.md Fri Aug 19 17:24:50 2016
@@ -6,7 +6,8 @@
$ svn checkout https://svn.apache.org/repos/asf/phoenix
```
-2. Edit/Add source markdown files in `/src/site/markdown` directory
+2. Edit/Add source markdown files in `/src/site/markdown` directory.
+2. Edit `phoenix-docs/src/docsrc/help/phoenix.csv` to update Reference pages, adding any missing new words to `phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt`, and manually remove `site/publish/language/*.html`.
3. Run `build.sh` located at root to generate/update html web pages in `site/publish` directory
4. `svn commit` source markdown files and html web pages
Modified: phoenix/site/source/src/site/markdown/download.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/download.md?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/download.md (original)
+++ phoenix/site/source/src/site/markdown/download.md Fri Aug 19 17:24:50 2016
@@ -3,4 +3,4 @@
### [<u>Download Latest Phoenix Binary and Source Releases</u>](http://www.apache.org/dyn/closer.lua/phoenix/)
See our installation instructions [here](installation.html), our release notes [here](release_notes.html),
-and a list of new features [here](recent.html)
+and a list of fixes new features [here](https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12334393&projectId=12315120)
Modified: phoenix/site/source/src/site/markdown/recent.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/recent.md?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/recent.md (original)
+++ phoenix/site/source/src/site/markdown/recent.md Fri Aug 19 17:24:50 2016
@@ -2,6 +2,10 @@
As items are implemented from our road map, they are moved here to track the progress we've made:
+1. **[Namespace Mapping](https://issues.apache.org/jira/browse/PHOENIX-1311)**. Maps Phoenix schema to HBase namespace to improve isolation between different schemas. **Available in our 4.8 release**
+1. **[Hive Integration](https://issues.apache.org/jira/browse/PHOENIX-2743)**. Enables Hive to be used with Phoenix in support of joining huge tables to other huge tables. **Available in our 4.8 release**
+1. **[Local Index Improvements](https://issues.apache.org/jira/browse/PHOENIX-1734)**. Reworked local index implementation to guarantee colocation of table and index data and use supported HBase APIs for better maintainability. **Available in our 4.8 release**
+1. **[DISTINCT Query Optimization](https://issues.apache.org/jira/browse/PHOENIX-258)**. Push seek logic to server for SELECT DISTINCT and COUNT DISTINCT queries over the leading parts of the primary key leading to dramically better performance. **Available in our 4.8 release**
1. **[Transaction Support](transactions.html)**. Supports transactions by integrating with [Tephra](https://github.com/continuuity/tephra). **Available in our 4.7 release**
1. **[Time series Optimization](rowtimestamp.html)**. Optimizes queries against time series data as explained in more detail [here](https://blogs.apache.org/phoenix/entry/new_optimization_for_time_series). **Available in our 4.6 release**
1. **[Asynchronous Index Population](secondary_indexing.html#Asynchronous_Index_Population)**. Enables an index to be created asynchronously using a map reduce job. **Available in our 4.5 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=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/roadmap.md (original)
+++ phoenix/site/source/src/site/markdown/roadmap.md Fri Aug 19 17:24:50 2016
@@ -2,15 +2,18 @@
Our roadmap is driven by our user community. Below, in prioritized order, is the current plan for Phoenix:
-1. **[Apache Calcite](https://calcite.incubator.apache.org/) Adapter**. Create a Phoenix adapter for Calcite to increase the breadth of our SQL support, plug into a rich cost-based optimizer framework, and enable potential interop with other adapters. **See our [calcite branch](https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/calcite) to try this and track our progress.**
-2. **[JSON Support](https://issues.apache.org/jira/browse/PHOENIX-628)**. Support a JSON data type and implement the standard operators and built-in functions similar to Postgres. **See our [json branch](https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/json) to try this and track our progress.**
-10. **[Monitoring and Management Improvements](https://issues.apache.org/jira/browse/PHOENIX-1121)**. Though we support [tracing](tracing.html) now, there's more work to do to better _operationalize_ Phoenix.
+1. **[Stress testing](https://issues.apache.org/jira/browse/PHOENIX-3146)**. Open source and automate the running of stress tests that exercise Phoenix and HBase under high load.
+1. **[Compatibility testing](https://issues.apache.org/jira/browse/PHOENIX-3183)**. Open source and automate the running of backward compatibility tests for Phoenix and HBase, including new server versions of Phoenix working with older client versions and unreleased HBase versions compiling with existing Phoenix versions.
+1. **[Atomic update](https://issues.apache.org/jira/browse/PHOENIX-2909)**. Support an UPDATE statement that runs atomically for a row updates of non transactional tables as a means to expose check-and-put and increment functionality for Phoenix.
+1. **[Column encoding](https://issues.apache.org/jira/browse/PHOENIX-1598)**. Providing an indirection between the column name and the column qualifier reduces storage space, improves performance and opens the door for enhancements such as renaming columns and dropping columns asynchronously.
+1. **[Immutable data packing](https://issues.apache.org/jira/browse/PHOENIX-2565)**. Since columns in immutable tables are not updated individually, but only inserted together, we can pack all values in a single cell to reduce storage space and improve performance.
+1. **[Apache Calcite adapter](https://calcite.incubator.apache.org/)**. Create a Phoenix adapter for Calcite to increase the breadth of our SQL support, plug into a rich cost-based optimizer framework, and enable potential interop with other adapters. **See our [calcite branch](https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/calcite) to try this and track our progress.**
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.
1. **[Join Improvements](https://issues.apache.org/jira/browse/PHOENIX-1167)**. Enhance our join capabilities in a variety of ways:<br/>
* **[Table-stats-guided choice between hash join and sort-merge join](https://issues.apache.org/jira/browse/PHOENIX-1556)**. Base hash join versus many-to-many decision on how many guideposts will be traversed for RHS table(s).
* **[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.
-2. **[Subquery](subqueries.html) Enhancement**, which includes support for **[correlated subqueries in the HAVING clause](https://issues.apache.org/jira/browse/PHOENIX-1388)** and **[using subqueries as expressions](https://issues.apache.org/jira/browse/PHOENIX-1392)**.
+2. **[Subquery enhancements](subqueries.html)**, which includes support for **[correlated subqueries in the HAVING clause](https://issues.apache.org/jira/browse/PHOENIX-1388)** and **[using subqueries as expressions](https://issues.apache.org/jira/browse/PHOENIX-1392)**.
6. **[DEFAULT declaration](https://issues.apache.org/jira/browse/PHOENIX-476)**. When creating a table, we should allow a DEFAULT declaration in our CREATE TABLE statement.
7. **[STRUCT type](https://issues.apache.org/jira/browse/PHOENIX-477)**. Allow declarations of multiple fields of different data types that would be packed into a single cell to reduce the per column storage overhead.
17. **[OLAP Extensions](https://issues.apache.org/jira/browse/PHOENIX-154)**. Support the `WINDOW`, `PARTITION OVER`, `RANK`, and other SQL-92 extensions.
@@ -21,4 +24,3 @@ Our roadmap is driven by our user commun
* **[Surface support for encryption](https://issues.apache.org/jira/browse/PHOENIX-673)**. Surface specification of what should be encrypted now that HBase supports transparent encryption.
* **[Support Cell-level security](https://issues.apache.org/jira/browse/PHOENIX-684)**. Surface cell-level security now that HBase supports it.
19. **Schema Evolution**. Phoenix supports adding and removing columns through the [ALTER TABLE] (language/index.html#alter) DDL command, but changing the data type of, or renaming, an existing column is not yet supported.
-20. **[Apache Sqoop integration](https://issues.apache.org/jira/browse/PHOENIX-763)**. Enable Sqoop to import Phoenix-compliant HBase tables from relational databases.
Modified: phoenix/site/source/src/site/markdown/views.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/views.md?rev=1756947&r1=1756946&r2=1756947&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/views.md (original)
+++ phoenix/site/source/src/site/markdown/views.md Fri Aug 19 17:24:50 2016
@@ -47,9 +47,8 @@ In addition, you may create an INDEX ove
Views have the following restrictions:
1. An INDEX over a VIEW is only maintained if the updates are made through the VIEW. Updates made through the underlying TABLE or the parent VIEW will not be reflected in the index ([PHOENIX-1499](https://issues.apache.org/jira/browse/PHOENIX-1499)).
-2. A column of a table may not be dropped once it has VIEWs ([PHOENIX-2156](https://issues.apache.org/jira/browse/PHOENIX-2156)).
3. A primary key column may not be added to a VIEW when its base table has a primary key constraint that ends with a variable length column ([PHOENIX-2157](https://issues.apache.org/jira/browse/PHOENIX-2157)).
4. A VIEW may be defined over only a single table through a simple SELECT * query. You may not create a VIEW over multiple, joined tables nor over aggregations ([PHOENIX-1505](https://issues.apache.org/jira/browse/PHOENIX-1505), [PHOENIX-1506](https://issues.apache.org/jira/browse/PHOENIX-1506)).
-5. If a VIEW is derived from another VIEW, the indexes from the base/derived VIEW will not be considered when executing queries ([PHOENIX-1367](https://issues.apache.org/jira/browse/PHOENIX-1367)).
+5. If a VIEW is derived from another VIEW, the indexes from the parent VIEW will not be considered when executing queries ([PHOENIX-1367](https://issues.apache.org/jira/browse/PHOENIX-1367)).
6. All columns must be projected into a VIEW when it's created (i.e. only CREATE VIEW ... AS SELECT * is supported). Note, however, you may drop non primary key columns inherited from the base table in a VIEW after it is created through the ALTER VIEW command. Providing a subset of columns and or expressions in the SELECT clause will be supported in a future release ([PHOENIX-1507](https://issues.apache.org/jira/browse/PHOENIX-1507)).