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)