hey Guys ,
I am trying to index data from hive into elasticsearch , however when i ran the below query , there is no error and index is not created in elasticsearch.
create external table es_names_text (employeeid int,firstname string,title string,state string,laptop string) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = 'es_names_text/employee', 'es.nodes'='localhost','es.port'='9200','es.index.auto.create' = 'true') ;
It is a single node cluster Also if i try to insert data into this , below snippet is show indefinitely
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Also i have not created index explicitly on elasticsearch.
please let me know how to create it and insert data without waiting for mr job to execute.
edit note:- elasticsearch and hadoop and hive are on the same machine but are on installed using different user id's. Hadoop and hive in login A and elasticsearch on login B. does this affect hive connecting to elasticsearch ?