Author: chinmayskulkarni Date: Wed Oct 16 21:43:34 2019 New Revision: 1868521
URL: http://svn.apache.org/viewvc?rev=1868521&view=rev Log: PHOENIX-5500: Add documentation for Exec permission requirements on SYSTEM.CHILD_LINK for creating views Modified: phoenix/site/publish/language/datatypes.html phoenix/site/publish/language/functions.html phoenix/site/publish/language/index.html phoenix/site/publish/views.html phoenix/site/source/src/site/markdown/views.md Modified: phoenix/site/publish/language/datatypes.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1868521&r1=1868520&r2=1868521&view=diff ============================================================================== --- phoenix/site/publish/language/datatypes.html (original) +++ phoenix/site/publish/language/datatypes.html Wed Oct 16 21:43:34 2019 @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2019-09-16 + Generated by Apache Maven Doxia at 2019-10-16 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=1868521&r1=1868520&r2=1868521&view=diff ============================================================================== --- phoenix/site/publish/language/functions.html (original) +++ phoenix/site/publish/language/functions.html Wed Oct 16 21:43:34 2019 @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2019-09-16 + Generated by Apache Maven Doxia at 2019-10-16 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=1868521&r1=1868520&r2=1868521&view=diff ============================================================================== --- phoenix/site/publish/language/index.html (original) +++ phoenix/site/publish/language/index.html Wed Oct 16 21:43:34 2019 @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2019-09-16 + Generated by Apache Maven Doxia at 2019-10-16 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/views.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1868521&r1=1868520&r2=1868521&view=diff ============================================================================== --- phoenix/site/publish/views.html (original) +++ phoenix/site/publish/views.html Wed Oct 16 21:43:34 2019 @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2019-07-10 + Generated by Apache Maven Doxia at 2019-10-16 Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> @@ -166,7 +166,7 @@ <div class="page-header"> <h1>Views</h1> </div> -<p>The standard SQL view syntax (with some limitations) is now supported by Phoenix to enable multiple virtual tables to all share the same underlying physical HBase table. This is important in HBase as there are limits to the number of Regions which HBase can manage. Limiting the number of tables can help limit the number of Regions in a cluster.</p> +<p>The standard SQL view syntax (with some limitations) is now supported by Phoenix to enable multiple virtual tables to all share the same underlying physical HBase table. This is important in HBase as there are limits to the number of regions which HBase can manage. Limiting the number of tables can help limit the number of regions in a cluster.</p> <p>For example, given the following table definition that defines a base table to collect product metrics:</p> <div class="source"> <pre>CREATE TABLE product_metrics ( @@ -185,6 +185,7 @@ WHERE metric_type = 'm'; </pre> </div> <p>In this case, the same underlying physical HBase table (i.e. PRODUCT_METRICS) stores all of the data. Notice that unlike with standard SQL views, you may define additional columns for your view. The view inherits all of the columns from its base table, in addition to being able to optionally add new KeyValue columns. You may also add these columns after-the-fact with an ALTER VIEW statement. </p> +<p><b>NOTE</b>: Phoenix 4.15.0 onwards contains <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-4810";>PHOENIX-4810</a> which introduces a new endpoint coprocessor on the SYSTEM.CHILD_LINK table for adding parent->child links, whenever a view is created. Thus, when namespace mapping is enabled, users that wish to create views will need to be granted EXEC permissions on SYSTEM.CHILD_LINK in order to be able to invoke this coprocessor.</p> <div class="section"> <h2 id="Updatable_Views">Updatable Views</h2> <p>If your view uses only simple equality expressions in the WHERE clause, you are also allowed to issue DML against the view. These views are termed <i>updatable views</i>. For example, in this case you could issue the following UPSERT statement:</p> Modified: phoenix/site/source/src/site/markdown/views.md URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/views.md?rev=1868521&r1=1868520&r2=1868521&view=diff ============================================================================== --- phoenix/site/source/src/site/markdown/views.md (original) +++ phoenix/site/source/src/site/markdown/views.md Wed Oct 16 21:43:34 2019 @@ -1,6 +1,6 @@ #Views -The standard SQL view syntax (with some limitations) is now supported by Phoenix to enable multiple virtual tables to all share the same underlying physical HBase table. This is important in HBase as there are limits to the number of Regions which HBase can manage. Limiting the number of tables can help limit the number of Regions in a cluster. +The standard SQL view syntax (with some limitations) is now supported by Phoenix to enable multiple virtual tables to all share the same underlying physical HBase table. This is important in HBase as there are limits to the number of regions which HBase can manage. Limiting the number of tables can help limit the number of regions in a cluster. For example, given the following table definition that defines a base table to collect product metrics: @@ -19,6 +19,8 @@ You may define the following view: In this case, the same underlying physical HBase table (i.e. PRODUCT_METRICS) stores all of the data. Notice that unlike with standard SQL views, you may define additional columns for your view. The view inherits all of the columns from its base table, in addition to being able to optionally add new KeyValue columns. You may also add these columns after-the-fact with an ALTER VIEW statement. +**NOTE**: Phoenix 4.15.0 onwards contains [PHOENIX-4810](https://issues.apache.org/jira/browse/PHOENIX-4810) which introduces a new endpoint coprocessor on the SYSTEM.CHILD_LINK table for adding parent->child links, whenever a view is created. Thus, when namespace mapping is enabled, users that wish to create views will need to be granted EXEC permissions on SYSTEM.CHILD_LINK in order to be able to invoke this coprocessor. + ## Updatable Views If your view uses only simple equality expressions in the WHERE clause, you are also allowed to issue DML against the view. These views are termed *updatable views*. For example, in this case you could issue the following UPSERT statement:
