[ 
https://issues.apache.org/jira/browse/PHOENIX-978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14604376#comment-14604376
 ] 

ASF GitHub Bot commented on PHOENIX-978:
----------------------------------------

GitHub user elilevine opened a pull request:

    https://github.com/apache/phoenix/pull/91

    PHOENIX-978: allow views to extend parent's PK

    https://issues.apache.org/jira/browse/PHOENIX-978

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/91.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 #91
    
----
commit 7e32f2566e56c1f7f5f0363806c7e3b81d37a9cb
Author: Eli Levine <elilev...@apache.org>
Date:   2015-06-26T18:36:06Z

    PHOENIX-978: Allow views to extend parent's PK in CREATE VIEW

commit 0f33522ffbb0ddc09cd94bd02221a370c696276b
Author: Eli Levine <elilev...@apache.org>
Date:   2015-06-26T21:57:16Z

    PHOENIX-978: Allow views to extend parent's PK in ALTER VIEW + associated 
test fixes

commit a9169f40f4c285757e91775de1b76850b832daa7
Author: Eli Levine <elilev...@apache.org>
Date:   2015-06-27T21:27:17Z

    PHOENIX-978: Make verification in ViewIT.testViewAddsNotNullPKColumn() more 
strict

----


> Allow views to extend base table's PK
> -------------------------------------
>
>                 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
>
>
> 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)

Reply via email to