# Issue when adding data to ES index from Hive External Table **URL:** \ **Category:** Elasticsearch\ **Tags:** es-hadoop\ **Created:** [June 9, 2016, 2:54am UTC](https://discuss.elastic.co/t/issue-when-adding-data-to-es-index-from-hive-external-table/52270 "2016-06-09T02:54:24Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Gaitonde](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Gaitonde](https://discuss.elastic.co/u/Gaitonde)\ **Post date:** [June 9, 2016, 2:54am UTC](https://discuss.elastic.co/t/issue-when-adding-data-to-es-index-from-hive-external-table/52270/1 "2016-06-09T02:54:24Z")
**I am trying to create Elastic search index using external table in Hive.** _Drop table hdce.ES\_Ext\_movies;_ _CREATE EXTERNAL TABLE hdce.ES\_Ext\_movies (_ _ts\_epoch bigint ,_ _movie\_name string)_ _STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'_ _TBLPROPERTIES('es.nodes' = 'localhost', 'es.port' = '9201', 'es.nodes.client.only' = 'true', 'es.resource.write ' = 'fromhive/test',_ _'es.index.auto.create' = 'true');_ **Inserted records into it** _Insert overwrite table hdce.ES\_Ext\_movies select unix\_timestamp(current\_timestamp) , A.movie\_name from hdce.movies A limit 10;_ **I am getting error:** INFO : Number of reduce tasks determined at compile time: 1 INFO : In order to change the average load for a reducer (in bytes): INFO : set hive.exec.reducers.bytes.per.reducer= INFO : In order to limit the maximum number of reducers: INFO : set hive.exec.reducers.max= INFO : In order to set a constant number of reducers: INFO : set mapreduce.job.reduces= INFO : number of splits:1 INFO : Submitting tokens for job: job\_1465210153149\_0115 INFO : The url to track the job: h ttp://hdfc02nn01.amr.corpcom:8088/proxy/application\_1465210153149\_0115/ INFO : Starting Job = job\_1465210153149\_0115, Tracking URL = h ttp://hdfc02nn01.amr.corpcom:8088/proxy/application\_1465210153149\_0115/ INFO : Kill Command = /opt/cloudera/parcels/CDH-5.5.1-1.cdh5.5.1.p0.11/lib/hadoop/bin/hadoop job -kill job\_1465210153149\_0115 INFO : Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 1 INFO : 2016-06-08 19:48:46,065 Stage-0 map = 0%, reduce = 0% INFO : 2016-06-08 19:48:54,531 Stage-0 map = 100%, reduce = 0%, Cumulative CPU 2.34 sec INFO : 2016-06-08 19:49:23,987 Stage-0 map = 100%, reduce = 100%, Cumulative CPU 2.34 sec INFO : MapReduce Total cumulative CPU time: 2 seconds 340 msec ERROR : Ended Job = job\_1465210153149\_0115 with errors Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2) **the reducer job shows this error on the logs** Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{},"value":{"\_col0":1465440517,"\_col1":"GoldenEye (1995)"}} at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:265) at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444) at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{},"value":{"\_col0":1465440517,"\_col1":"GoldenEye (1995)"}} at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:253) ... 7 more Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException: 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' at org.apache.hadoop.hive.ql.exec.FileSinkOperator.createBucketFiles(FileSinkOperator.java:523) at.. **Do we know what is the issue?** Thanks. ---
**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\ **Post date:** [June 9, 2016, 6:17pm UTC](https://discuss.elastic.co/t/issue-when-adding-data-to-es-index-from-hive-external-table/52270/2 "2016-06-09T18:17:41Z")
You have `es.nodes` configured to be "localhost". Is your installation of Hive running entirely locally? I only ask because I see Hive reporting a job tracking url that looks remote : `http://hdfc02nn01.amr.corpcom:8088/proxy/application_1465210153149_0115/` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:24pm UTC](https://discuss.elastic.co/t/issue-when-adding-data-to-es-index-from-hive-external-table/52270/3 "2017-07-06T13:24:24Z")