You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Xinyi Yan (JIRA)" <ji...@apache.org> on 2019/02/05 04:12:00 UTC
[jira] [Comment Edited] (PHOENIX-2265) Disallow creation of view
over HBase table if PK not specified
[ 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 4:11 AM:
------------------------------------------------------------
[~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.
was (Author: yanxinyi):
if nobody is working on this one, I will do it.
> 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)