# ES-Hadoop Hive Integration with TLS/SSL Security
**URL:** https://discuss.elastic.co/t/es-hadoop-hive-integration-with-tls-ssl-security/222853
**Category:** Elasticsearch
**Tags:** elastic-stack-security, es-hadoop
**Created:** [March 10, 2020, 4:38am UTC](https://discuss.elastic.co/t/es-hadoop-hive-integration-with-tls-ssl-security/222853 "2020-03-10T04:38:06Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@gsahu25](https://discuss.elastic.co/u/gsahu25)
#### Post date: [March 10, 2020, 4:38am UTC](https://discuss.elastic.co/t/es-hadoop-hive-integration-with-tls-ssl-security/222853/1 "2020-03-10T04:38:06Z")
Hi,
I have set-up a cluster with 3 master, 4 DI nodes. Also I have enabled TLS/SSL with self signed CA. The .p12 files I have generated for elasticsearch nodes are IP based.
Now I am trying to connect to ES cluster using ES-hadoop connectors. What all set-up required for .p12 for nodes on my hadoop cluster? Should they be IP based or generic one should work fine? How I register it on hadoop nodes into keystore truststore?
Any link to a documentation to configure these?
Regards,
Gopal
---
### Author:  [@gsahu25](https://discuss.elastic.co/u/gsahu25)
#### Post date: [March 10, 2020, 6:21am UTC](https://discuss.elastic.co/t/es-hadoop-hive-integration-with-tls-ssl-security/222853/2 "2020-03-10T06:21:44Z")
I have a node.p12 file which I have added using ADD FILE hdfs:///tmp/node.p12 in hive.
When I do a list, it shows this file added to distributed cache on the cluster. However I am still getting error when I try to insert records into the hive table.
org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Expected to find keystore file at [node.p12] but was unable to. Make sure that it is available on the classpath, of if not, that you have specified a valid file URI.
Below properties are used in Hive table DDL:
'es.net.http.auth.user'='user',
'es.net.http.auth.pass'='pass',
'es.net.ssl.cert.allow.self.signed'='true',
'es.net.ssl'='true',
'es.net.ssl.keystore.type'='PKCS12',
'es.keystore.location'='node.p12',
'es.net.ssl.keystore.location'='node.p12',
'es.net.ssl.truststore.location'='node.p12'
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 7, 2020, 6:21am UTC](https://discuss.elastic.co/t/es-hadoop-hive-integration-with-tls-ssl-security/222853/3 "2020-04-07T06:21:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.