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.

Phoenix connection error while secure Hbase cluster, but executes successfully

Highlighted

Phoenix connection error while secure Hbase cluster, but executes successfully

New Contributor

I use squirrel with a key tab, and we have all tables in a different schema and not in default.

I connect succecssfully using squirrel.

In java code , when i run it, though it executes the statement (query or persist ), but it gives me error.

And i think i havent set a schema, thats why its throwing this error.

query : select snapshot_ts from myschema.mytable

Above query has a schema name attached.

Now i use mybatis in my java code. And yes this is first time i m connecting through java.

And if url is same both for squirrel and in java code, i dont expect java code to throw error(though it works) while squirrel works fine.

org.apache.hadoop.hbase.security.AccessDeniedException: org.apache.hadoop.hbase.security.AccessDeniedException: Insufficient permissions (user=myuserid@mydomain.COM, scope=SYSTEM, params=[namespace=SYSTEM,table=SYSTEM:CATALOG],action=CREATE) at org.apache.hadoop.hbase.security.access.AccessController.requireNamespacePermission(AccessController.java:628)

..

..

Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException: org.apache.hadoop.hbase.security.AccessDeniedException: Insufficient permissions (user=myuserid@mydomain.COM, scope=SYSTEM, params=[namespace=SYSTEM,table=SYSTEM:CATALOG],action=CREATE)

at org.apache.hadoop.hbase.security.access.AccessController.requireNamespacePermission(AccessController.java:628)

..

..

2018-04-27 16:30:53.173 WARN --- [ main] o.a.p.query.ConnectionQueryServicesImpl : Could not check for Phoenix SYSTEM tables, assuming they exist and are properly configured