Access denied reading dataset ***.schema.**** from HIVE 3.0 Source

1

Hi Team,

We are using dremio version 4.1.4 and we have added hive (CDP 7.1.3 kerberized cluster) 3.x source.

We are getting below error while doing query on external table .

2021-01-22 10:53:42,707 [qtp1458373195-177] INFO c.d.e.catalog.PermissionCheckCache - User Error Occurred [ErrorId: 682d1c31-1eb6-4d6c-b200-40414a290c1c]
com.dremio.common.exceptions.UserException: Access denied reading dataset .schema.**.

Caused by: com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: java.lang.RuntimeException: class org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizerFactory not org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizerFactory

Caused by: java.lang.RuntimeException: java.lang.RuntimeException: class org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizerFactory not org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizerFactory
Caused by: java.lang.RuntimeException: class org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizerFactory not org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizerFactory
at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2621) ~[hadoop-common-3.2.0-dremio-201911062242240641-139525f.jar:na]
… 103 common frames omitted

Regards,
Atul

2

@achounde

CDP 7.1 is only supported in Dremio 12.0. In that also, Dremio does not support managed tables but only support External tables for PARQUET

Please upgrade to Dremio 12.0. Do you use external and managed tables? What are your file formats?

Thanks
Bali