Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

View hbase tables in phoenix

View hbase tables in phoenix

Explorer

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

 

2 REPLIES 2

Re: View hbase tables in phoenix

Master Guru
It appears that Phoenix has only recently completed work to properly
support non-default namespaces, via
https://issues.apache.org/jira/browse/PHOENIX-1311.

Re: View hbase tables in phoenix

Contributor

HBase namespace support is added in Phoenix 4.8.  Hortonworks has backported it to their version of 4.7.0 - the HDP 2.6 Ambari now supports the parameter switch "phoenix.schema.isNamespaceMappingEnabled"

 

When will Cloudera upgrade its Phoenix distro (or better, integrate it into CDH and HBase)?  Currently, this feature disparity has broken bulk data migration between CDH and HDP - Phoenix Spark plugin cannot access tables on both clusters within the same application.

 

2017-08-21 16:12:38,048 INFO  [main] impl.MetricsSystemImpl: phoenix metrics system started
java.sql.SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properites.. Ensure that config phoenix.schema.isNamespaceMappingEnabled is consitent on client and server.