Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

View hbase tables in phoenix

avatar
Contributor

Hi

I have installed apache phoenix(version 4.7) on CDH/HBASEVersion 1.2.0-cdh5.7.1

I have various namespaces in hbase and would like to create views on those in phoenix for browsing hbase data. Tried various searches online and couldnt find any insights...although there are tons of examples more or less showing same logic...there arent any which refer to different namespaces in hbase...tried various ways and get error..

Hope someone can help.

Here is my htable -

hbase(main):002:0> describe 'dev_fcra:rtics_inquiry'
Table dev_fcra:rtics_inquiry is ENABLED
dev_fcra:rtics_inquiry, {TABLE_ATTRIBUTES => {MAX_FILESIZE => '21474836480'}
COLUMN FAMILIES DESCRIPTION
{NAME => 'f', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'SNAPPY', MIN_VERSIONS => '0', TTL => '220752000 SECONDS (2555 DAYS)', KEEP_DELETED_CELLS => 'FALSE',
BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
1 row(s) in 0.1300 seconds

 

When I login to phoenix using sqlline.py it uses default namespace....

 

Thanks

 

Who agreed with this topic