Presto - Hive connector - Unable to query the data from hdfs encryption zones


ramireddy.sunkara@...
 

Hi Team,

 

We did the presto setup (version – 0.253) on one coordinator (master node), 7  worker nodes (data nodes) and presto CLI on the edge node of the Cloudera CDH cluster – 6.2.1.

 

We are able to run the presto queries against the data present in Hadoop via hive connector.

 

We are getting the below issue when running the queries against the data present in hdfs encryption zones (Key Trustee KMS) – Data at rest.

 

Failed: Error opening the Hive split hdfs://<path>: No KeyProvider is configured, cannot access an encrypted file.

Caused by java.io.IOException: No KeyProvider is configured, cannot access an encrypted file.

 

Could not find the relevant property in the hive connector section of the Presto documentation. (could this be a limitation.. I doubt).

 

Could you please let me know if you come across this problem and solutions in any of your implementations.

 

Appreciate your inputs and happy to get connected and discuss in details.

 

Thank you in advance..

 

Regards

Rami


ramireddy.sunkara@...
 

Hi Team,

Could you please share an update if we have any ways to query data from hdfs encyption zones. 

Regards
Rami