[ 
https://issues.apache.org/jira/browse/PHOENIX-7034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Istvan Toth updated PHOENIX-7034:
---------------------------------
    Description: 
Currently it is possible to create a mapped view on an HBase table even if the 
schema is not created in phoenix.
We should throw a schema does not exists error similarly to the table creation.

Steps to repro:

 
{noformat}
hbase shell
create_namespace 'T'
create 'T:T1’, {NAME => 'f1', VERSIONS => 5}
put 'T:T1', '1', 'f1:lastname', 'Foo'
{noformat}
 

 

phoenix-sqlline
{noformat}
CREATE VIEW "T.T1" ( pk VARCHAR PRIMARY KEY, "f1"."lastname" VARCHAR 
);{noformat}

  was:
Currently it is possible to create a mapped view on an HBase table even if the 
schema is not created in phoenix.
We should throw a schema does not exists error similarly to the table creation.

Steps to repro:

hbase shell

create_namespace 'T'

create 'T:T1’, \{NAME => 'f1', VERSIONS => 5}

put 'T:T1', '1', 'f1:lastname', 'Foo'

 

phoenix-sqlline

CREATE VIEW "T.T1" ( pk VARCHAR PRIMARY KEY, "f1"."lastname" VARCHAR );


> Disallow mapped view creation when the schema does not exists
> -------------------------------------------------------------
>
>                 Key: PHOENIX-7034
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7034
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.2.0, 5.1.3
>            Reporter: Richárd Antal
>            Priority: Major
>
> Currently it is possible to create a mapped view on an HBase table even if 
> the schema is not created in phoenix.
> We should throw a schema does not exists error similarly to the table 
> creation.
> Steps to repro:
>  
> {noformat}
> hbase shell
> create_namespace 'T'
> create 'T:T1’, {NAME => 'f1', VERSIONS => 5}
> put 'T:T1', '1', 'f1:lastname', 'Foo'
> {noformat}
>  
>  
> phoenix-sqlline
> {noformat}
> CREATE VIEW "T.T1" ( pk VARCHAR PRIMARY KEY, "f1"."lastname" VARCHAR 
> );{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to