# Elasticsearch-hive Storage handler exception

**URL:** https://discuss.elastic.co/t/elasticsearch-hive-storage-handler-exception/119993
**Category:** Elasticsearch
**Tags:** es-hadoop
**Created:** [February 15, 2018, 1:28pm UTC](https://discuss.elastic.co/t/elasticsearch-hive-storage-handler-exception/119993 "2018-02-15T13:28:11Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sat](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@sat](https://discuss.elastic.co/u/sat)
#### Post date: [February 15, 2018, 1:28pm UTC](https://discuss.elastic.co/t/elasticsearch-hive-storage-handler-exception/119993/1 "2018-02-15T13:28:11Z")

</div>

Hi  
i am trying to get elasticsearch data in to hive external table,  
CREATE EXTERNAL TABLE eshadoop(  
name String  
)  
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'  
TBLPROPERTIES('es.nodes' = 'XXXX:9200',  
'es.resource' = 'eshadoop/event',  
'es.net.ssl' = 'true',  
'es.net.http.auth.user' = 'XXX',  
'es.net.http.auth.pass' = 'XXXX',  
'es.index.read.missing.as.empty' =' true',  
'es.mapping.names' = 'name:name',  
'es.net.ssl.protocol' = 'TLSv1.2',  
'es.net.ssl.cert.allow.self.signed' = 'true');  
i am able to create table but cant read data, getting below error  
FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: Error in loading storage handler.org.elasticsearch.hadoop.hive.EsStorageHandler  
or  
TSocket read 0 bytes (code THRIFTTRANSPORT): TTransportException('TSocket read 0 bytes',)

can you please suggest how to sort out this issue.  
Thanks

---

<div class="post-metadata">

### Author: ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)
#### Post date: [March 1, 2018, 9:38pm UTC](https://discuss.elastic.co/t/elasticsearch-hive-storage-handler-exception/119993/2 "2018-03-01T21:38:41Z")

</div>

Could you include any more information about the errors, such as the logs or stack traces that go along with them, which versions of everything you are using, etc?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 29, 2018, 9:38pm UTC](https://discuss.elastic.co/t/elasticsearch-hive-storage-handler-exception/119993/3 "2018-03-29T21:38:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.