[
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)
