Support Questions
Find answers, ask questions, and share your expertise

Phoenix connection error while secure Hbase cluster, but executes successfully

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

Don't have an account?