Hi,
I am trying to add hive table into Elasticsearch. Have added the jar in hive-site.xml file.
CDH 5.11
Hadoop 2.6
Hive 1.1.0
elasticsearch-hadoop-7.3.2.jar
Elasticsearch 7.3.2
I am able to successfully create table using below command
CREATE EXTERNAL TABLE elkdummy (
name STRING,
id INT)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.nodes' = '192.168.4.23', 'es.resource' = 'hive-elastic/log', 'es.query' = '?q=*');
But when I try to insert data using below command
INSERT INTO TABLE elkdummy VALUES ('elastic',1);
I get below error
Caused by: java.lang.ClassNotFoundException: org.elasticsearch.hadoop.hive.EsHiveInputFormat
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at org.apache.hive.com.esotericsoftware.kryo.util.DefaultClassResolver.readName(DefaultClassResolver.java:136)
... 49 more
I want to understand why the create query is getting executed but the insert query is not?