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
