phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-978) Allow views to extend base table's PK (only if last PK column is fixed length)
Date Tue, 14 Jul 2015 02:13:05 GMT


Hudson commented on PHOENIX-978:

SUCCESS: Integrated in Phoenix-master #833 (See [])
PHOENIX-978: Allow views to extend parent's PK only if parent's last PK column is fixed length
(tdsilva: rev 66705d5170496bed7c39bd484517722ac8d09a13)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/
* phoenix-core/src/it/java/org/apache/phoenix/end2end/
* phoenix-core/src/main/java/org/apache/phoenix/exception/
* phoenix-core/src/main/java/org/apache/phoenix/schema/

> Allow views to extend base table's PK (only if last PK column is fixed length)
> ------------------------------------------------------------------------------
>                 Key: PHOENIX-978
>                 URL:
>             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-v2.patch, 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

View raw message