You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ch...@apache.org on 2019/10/16 21:43:34 UTC
svn commit: r1868521 - in /phoenix/site: publish/language/datatypes.html
publish/language/functions.html publish/language/index.html
publish/views.html source/src/site/markdown/views.md
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: