Unable to connect with elasticsearch from hive

hi, iam trying to connect with elasticsearch to send the data from hive tables...
i added elastic-hadoop jar in hive working directory..

while creating hive tables iam gettinng error like ...could you tell possible solution for that

hive> CREATE EXTERNAL TABLE artists ( City String,State String,Join_date date,Salary double,Sex String,Age INT,Emp_Name String,Dno INT) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = 'radio/artists','es.index.auto.create' = 'true','es.nodes.wan.only'='false','es.nodes'='10.80.15.90:9200');
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible or when targeting a WAN/Cloud instance without the proper setting 'es.nodes.wan.only'

This typically happens if Hive cannot reach Elasticsearch. If you open up the HiveServer logs you should be able to find the full stack trace and see the root cause.

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