No KeyProvider is configured, cannot access an encrypted file

Viewed 24
2.1 catalog

hive集群开启了kerberos和TLS/SSL，查询非加密区数据正常，查询加密区表报错如下：
SQL Error [1105] [HY000]: errCode = 2, detailMessage = (W1PLPI-SPS08)[CANCELLED]cur path: hdfs://nameservice1/warehouse/tablespace/external/hive/ec_dws.db/fact_transaction/date_of_file=2020-03-23/007719_0. failed to open /warehouse/tablespace/external/hive/ec_dws.db/fact_transaction/date_of_file=2020-03-23/007719_0: (255), Unknown error 255), reason: IOException: No KeyProvider is configured, cannot access an encrypted file

____25
2 Answers

试试在创建属性加个能否解决 ：
"hive.exec.orc.split.strategy" = "BI"

张彬华7127

因文件是parquet格式，尝试加入参数"hive.exec.orc.split.strategy" = "BI",
"hive.exec.parquet.split.strategy" = "BI"还是报错。

____25