Issue With Elasticsearch Hadoop access , Please help me

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Issue With Elasticsearch Hadoop access , Please help me

itsprakashs
This post has NOT been accepted by the mailing list yet.
Hadoop - 2.6
Hive - apache-hive-1.2.0-bin
Elasticsearch - 1.4.4
aux_lib - elasticsearch-hadoop-2.1.0.BUILD-20150606.023546-425.jar
-------------------------------------------

CREATE EXTERNAL TABLE wikitable (
title string,
redirect_page string )
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'wikipedia_river/page',
'es.query'='?q=buckethead',
'es.host' = 'localhost',
'es.port' = '9200') --- created table successfully..............

hive> select count(distinct title) from wikitable;

Job Submission failed with exception 'org.elasticsearch.hadoop.EsHadoopIllegalArgumentException(Index [wikipedia_river/page] missing and settings [es.field.read.empty.as.null] is set to false)'
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask