phoenix-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jamestay...@apache.org
Subject 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/
Date Fri, 19 Aug 2016 17:24:51 GMT
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&amp;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)).
 



Mime
View raw message