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)).
