Phoenix View on pre-existing HBase namespace table?

[liqw1016]

Hey,

When I try to create a Phoenix View on a pre-existing HBase namespace table throws below error:

0: jdbc:phoenix:bigdata01.zk.tuniu.org> CREATE VIEW "wwc_beck"."t1" ("pk" VARCHAR PRIMARY KEY, "f1"."a" VARCHAR, "f1"."b" VARCHAR, "f1"."c" VARCHAR);

Error: ERROR 505 (42000): Table is read only. (state=42000,code=505) org.apache.phoenix.schema.ReadOnlyTableException: ERROR 505 (42000): Table is read only. at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1034) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1399) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2275) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:939) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:211) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:358) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:341) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:339) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1511) at sqlline.Commands.execute(Commands.java:822) at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:813) at sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) 0: jdbc:phoenix:bigdata01.zk.tuniu.org>

Table in HBase like this:

hbase(main):001:0>create 'wwc_beck:t1', {NAME => 'f1', VERSIONS => 5}

hbase(main):002:0>put 'wwc_beck:t1', 'row1', 'f1:a', 'value1'
hbase(main):003:0>put 'wwc_beck:t1', 'row2', 'f1:b', 'value2'
hbase(main):004:0>put 'wwc_beck:t1', 'row3', 'f1:c', 'value3'

hbase(main):005:0> scan "wwc_beck:t1"
ROW COLUMN+CELL
row1 column=f1:a, timestamp=1488101125183, value=value1
row2 column=f1:b, timestamp=1488101125267, value=value2
row3 column=f1:c, timestamp=1488101126005, value=value3
3 row(s) in 0.0230 seconds

liqw.

[collinmazb]

Anyone noticed this problem? Seems we couldn't create view on pre-existing HBase namespace table. We indeed could create on phoenix table, but when the next time you want to change the column type you'll have to drop the column, which leads to data been deleted. This's not acceptable