Created 06-08-2018 03:17 PM
I have a HBASE table as follows with 1000 rows , if I try to create a view on this from phoenix I get "
ERROR 505 (42000): Table is read only" error
if I create a table instead of a view it creates the table but I see no rows there .
hbase(main):001:0> describe 'UFM' Table UFM is ENABLED UFM COLUMN FAMILIES DESCRIPTION {NAME => 'EXLIST', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COM PRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} {NAME => 'F1', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COMPRES SION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} 2 row(s) in 0.3070 seconds
I create the phoenix view as follows :
CREATE VIEW "UFM_PHX" ( UFMID VARCHAR PRIMARY KEY, "EXLIST"."LIST1" varchar, "EXLIST"."LIST2" varchar, "EXLIST"."LIST3" varchar, "EXLIST"."LIST4" varchar, "EXLIST"."LIST5" varchar, "EXLIST"."LIST6" varchar, "EXLIST"."LIST7" varchar, "EXLIST"."LIST8" varchar, "EXLIST"."LIST9" varchar, "EXLIST"."LIST10" varchar, "EXLIST"."LIST11" varchar, "EXLIST"."LIST12" varchar, "EXLIST"."LIST13" varchar, "EXLIST"."LIST14" varchar, "EXLIST"."LIST15" varchar, "EXLIST"."LIST16" varchar, "EXLIST"."LIST17" varchar, "EXLIST"."LIST18" varchar, "EXLIST"."LIST19" varchar, "EXLIST"."LIST20" varchar, "EXLIST"."LIST21" varchar, "F1"."INSERT_TIME" date, "F1"."LANEID" varchar, "F1"."LANEUFMSEQNO" varchar, "F1"."PLAZAID" varchar, "F1"."TIPUFMSEQ" varchar, "F1"."TIP_ID" varchar, "F1"."TXNTM" date)
Created 06-08-2018 03:31 PM
found the issue .. the phoenix view should have the same name as the HBASE table .. Phoenix document does not state this
Created 06-08-2018 03:31 PM
found the issue .. the phoenix view should have the same name as the HBASE table .. Phoenix document does not state this