mapping HBASE table to Phoenix not working

aliyesami — Fri, 08 Jun 2018 22:17:16 GMT

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)

Re: mapping HBASE table to Phoenix not working

aliyesami — Fri, 08 Jun 2018 22:31:45 GMT

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

question Re: mapping HBASE table to Phoenix not working in Archives of Support Questions (Read Only)

mapping HBASE table to Phoenix not working

Re: mapping HBASE table to Phoenix not working