phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From C Reid <reidddc...@outlook.com>
Subject Create views on existing HBase namespace(not default) tables
Date Tue, 26 Dec 2017 08:46:50 GMT
Hi all,


I created a table from client code, and want to make queries through Phoenix.


Every thing works well, verified by "select *" statement, when table is in 'default' namespace,
no matter using

"create view "testKerberosCode" (pk VARCHAR PRIMARY KEY, "k"."" VARCHAR);"

or

"create table "testKerberosCode" (pk VARCHAR PRIMARY KEY, "k"."" VARCHAR);"


But when i created table in another namespace called 'reid', using

"create view "reid"."testKerberosCode" (pk VARCHAR PRIMARY KEY, "k"."" VARCHAR);" causes Error:
ERROR 505 (42000): Table is read only. (state=42000,code=505); using

"create table "reid"."testKerberosCode" (pk VARCHAR PRIMARY KEY, "k"."" VARCHAR);" causes
nothing, but "select *" shows empty.

I also tried method in this link: https://community.hortonworks.com/questions/65172/views-on-existing-hbase-namespace-tables.html,
and result of "select *" is empty...


Any hint is highly appreciated.


Best regards,

R.C

[https://dataworkssummit.com/wp-content/uploads/2017/11/HCC-Banner-Ad.jpg]<https://community.hortonworks.com/questions/65172/views-on-existing-hbase-namespace-tables.html>

Views on existing HBase namespace tables - Hortonworks<https://community.hortonworks.com/questions/65172/views-on-existing-hbase-namespace-tables.html>
community.hortonworks.com
First you can map the table created in HBase to Phoenix with create table query as mentioned
in "Mapping to an Existing HBase Table" at phoenix.apache.org and then ...




Phoenix version i'm using is phoenix-4.11.0-HBase-1.2



Mime
View raw message