[
https://issues.apache.org/jira/browse/PHOENIX-978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14619727#comment-14619727
]
ASF GitHub Bot commented on PHOENIX-978:
----------------------------------------
GitHub user elilevine opened a pull request:
https://github.com/apache/phoenix/pull/97
PHOENIX-978: Allow views to extend parent's PK only if parent's last …
…PK column is fixed length
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/elilevine/apache-phoenix PHOENIX-978
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/97.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #97
----
commit 70a1828acd951fc67aed7b66f30270237c615929
Author: Eli Levine <[email protected]>
Date: 2015-07-09T01:46:43Z
PHOENIX-978: Allow views to extend parent's PK only if parent's last PK
column is fixed length
----
> Allow views to extend base table's PK (only if last PK column is fixed length)
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-978
> URL: https://issues.apache.org/jira/browse/PHOENIX-978
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 3.0.0, 4.0.0
> Reporter: Eli Levine
> Assignee: Eli Levine
> Fix For: 5.0.0, 4.5.0
>
> Attachments: PHOENIX-978.diff
>
>
> CREATE VIEW syntax currently disallows PK constraint to be defined. As a
> result views and tenant-specific tables created using CREATE VIEW
> automatically inherit their base table's PK with no way to extend it.
> Base tables should be allowed to be created with a minimum of PK columns to
> support views, and views to extend PKs as desired. This would allow a single
> base table to support a heterogeneous set of views on top of it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
