Author: jamestaylor
Date: Thu Jul 30 06:02:09 2015
New Revision: 1693388
URL: http://svn.apache.org/r1693388
Log:
Update limitations on VIEW
Modified:
phoenix/site/publish/views.html
phoenix/site/source/src/site/markdown/views.md
Modified: phoenix/site/publish/views.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1693388&r1=1693387&r2=1693388&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Thu Jul 30 06:02:09 2015
@@ -191,13 +191,12 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<h2 id="Limitations">Limitations</h2>
<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 will not be reflected in
the index (<a class="externalLink"
href="https://issues.apache.org/jira/browse/PHOENIX-1499";>PHOENIX-1499</a>).</li>
- <li>The schema of a table may not be changed once it has VIEWs (<a
class="externalLink"
href="https://issues.apache.org/jira/browse/PHOENIX-1504";>PHOENIX-1504</a>).</li>
- <li>The primary key constraint of the base TABLE may not be changed by a
VIEW. In the future, adding to the primary key constraint may be possible (<a
class="externalLink"
href="https://issues.apache.org/jira/browse/PHOENIX-978";>PHOENIX-978</a>).</li>
+ <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>All columns must be projected into a VIEW (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>
- <li>A TABLE that has a VIEW may not be dropped, but instead all VIEWs must
be dropped first. As of the 3.2/4.2 release, <a class="externalLink"
href="http://phoenix.apache.org/language/index.html#drop_table";>DROP TABLE</a>
and <a class="externalLink"
href="http://phoenix.apache.org/language/index.html#drop_view";>DROP VIEW</a>
supports a CASCADE option which will cause all tenant-specific views to be
dropped as well.</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>
</div>
Modified: phoenix/site/source/src/site/markdown/views.md
URL:
http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/views.md?rev=1693388&r1=1693387&r2=1693388&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/views.md (original)
+++ phoenix/site/source/src/site/markdown/views.md Thu Jul 30 06:02:09 2015
@@ -46,11 +46,10 @@ In addition, you may create an INDEX ove
## Limitations
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 will not be reflected in the
index ([PHOENIX-1499](https://issues.apache.org/jira/browse/PHOENIX-1499)).
-2. The schema of a table may not be changed once it has VIEWs
([PHOENIX-1504](https://issues.apache.org/jira/browse/PHOENIX-1504)).
-3. The primary key constraint of the base TABLE may not be changed by a VIEW.
In the future, adding to the primary key constraint may be possible
([PHOENIX-978](https://issues.apache.org/jira/browse/PHOENIX-978)).
+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)).
-6. All columns must be projected into a VIEW (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)).
-7. A TABLE that has a VIEW may not be dropped, but instead all VIEWs must be
dropped first. As of the 3.2/4.2 release, [DROP
TABLE](http://phoenix.apache.org/language/index.html#drop_table) and [DROP
VIEW](http://phoenix.apache.org/language/index.html#drop_view) supports a
CASCADE option which will cause all tenant-specific views to be dropped as well.
+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)).
