I am using Hive 1.1.0 , Hadoop 2.6.0 and downloaded the elasticsearch-hadoop-2.1.0 jar file.
After following the instructions from the docs, I was able to create external table :
hive> CREATE EXTERNAL TABLE movies ( > movieid INT, > title STRING, > genres STRING) > STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' > TBLPROPERTIES('es.resource' = 'movietime/movies');
However, while trying to insert into the table I'm getting the following exception: https://gist.github.com/sherylj/ccd924be35537b4aa0e8
The elasticsearch-hadoop-2.1.0.jar is places in the $HIVE_HOME/lib. I've also specified the jar path in the hive-site.xml :
The jar is available on the HDFS in the above specified path. Hence, I'm confused as to why the error exception says the File is not found. Please let me know if I'm missing something or how I can fix it.