Elasticsearch-hive Storage handler exception

Elastic Stack Elasticsearch
1

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

2

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?

3

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