mapping HBASE table to Phoenix not working

[#1]

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)

[#2 · Accepted solution]

found the issue .. the phoenix view should have the same name as the HBASE table .. Phoenix document does not state this