phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xinyi Yan (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-2265) Disallow creation of view over HBase table if PK not specified
Date Tue, 05 Feb 2019 06:32:00 GMT

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

Xinyi Yan edited comment on PHOENIX-2265 at 2/5/19 6:31 AM:
------------------------------------------------------------

 [~jamestaylor] This is kind of weird, why we allow this view creation?

If system.catalog doesn't have the table's information, we should throw an error instead. 

Would you mind provide an example of the use case here so that I can have a better understanding,
thanks!


was (Author: yanxinyi):
 [~jamestaylor] This is kind of weird to me, why we allow this view creation?

If system.catalog doesn't have the table's information, we should throw an error instead. 

> Disallow creation of view over HBase table if PK not specified
> --------------------------------------------------------------
>
>                 Key: PHOENIX-2265
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2265
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Priority: Major
>              Labels: newbie
>
> We currently allow a Phoenix view to be defined over an HBase table without specifying
a primary key.
> To repro, create an HBase table in the HBase shell:
> {code}
>  create 'hb1', 'f1'
> {code}
> Then create a view in Phoenix:
> {code}
> create view "hb1"("f1".a varchar);
> {code}
> This should yield an error, as we haven't specified a primary key.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message