# INSERT OVERWRITE TABLE hangs

**URL:** <https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206>\
**Category:** Elasticsearch\
**Created:** [March 23, 2016, 10:39am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206 "2016-03-23T10:39:38Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 23, 2016, 10:39am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/1 "2016-03-23T10:39:38Z")

</div>

Dear All:

We just insert into an external table from existing one and it hangs on kill command:  
hive\> INSERT OVERWRITE TABLE user01 SELECT id,name FROM user\_source;  
Query ID = csi\_20160323182829\_c33296cf-9bd6-4809-8d0e-acb521dd1fcc  
Total jobs = 1  
Launching Job 1 out of 1  
Number of reduce tasks is set to 0 since there's no reduce operator  
Starting Job = job\_1458728756355\_0001, Tracking URL = [http://server1:8088/proxy/application\_1458728756355\_0001/](http://server1:8088/proxy/application_1458728756355_0001/)  
Kill Command = /home/csi/hadoop/bin/hadoop job -kill job\_1458728756355\_0001

any advice would be appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 24, 2016, 1:06am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/2 "2016-03-24T01:06:31Z")

</div>

any comment would be appreciated...

---

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 24, 2016, 2:34am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/3 "2016-03-24T02:34:06Z")

</div>

some errors from hive logs as follows:  
2016-03-24 10:31:17,614 INFO [main]: exec.Utilities (Utilities.java:getBaseWork(456)) - Fil e not found: File does not exist: /tmp/hive/csi/9aeb0c93-0e42-4907-80bd-6c46c773e2cc/hive\_20 16-03-24\_10-31-14\_052\_2790586764771909959-1/-mr-10002/476d8ea7-00d0-4248-8995-dcbbd9f773e4/r educe.xml  
at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:71)  
at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:61)  
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocationsInt(FSNamesy stem.java:1828)  
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocations(FSNamesyste m.java:1799)  
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocations(FSNamesyste m.java:1712)  
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getBlockLocations(NameNo deRpcServer.java:587)  
at [org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.ge](http://org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.ge) tBlockLocations(ClientNamenodeProtocolServerSideTranslatorPB.java:365)

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [March 24, 2016, 6:13am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/4 "2016-03-24T06:13:01Z")

</div>

Did you really post this in the right place? Seems like a Hadoop question that's completely unrelated to Elasticsearch.

---

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 24, 2016, 9:22am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/5 "2016-03-24T09:22:17Z")

</div>

we are trying to connect to es-hadoop from hive, any more comment would be appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 24, 2016, 9:31am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/6 "2016-03-24T09:31:50Z")

</div>

we created that external table successfully, there's an ever message during query:

hive\> select \* from user01;  
OK  
Failed with exception java.io.IOException:org.elasticsearch.hadoop.rest.EsHadoopNoNodesLeftException: Connection error (check network and/or proxy settings)- all nodes failed; tried [[127.0.0.1:9200]]  
Time taken: 0.128 seconds  
hive\>

---

<div class="post-metadata">

**Author:** ![Joe\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_yang/32/20719_2.png) [@Joe\_Yang](https://discuss.elastic.co/u/Joe_Yang)\
**Post date:** [March 24, 2016, 10:08am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/7 "2016-03-24T10:08:44Z")

</div>

we have creaed another issue one the es-hadoop forum, please close this one, soory for any convenience.

---

<div class="post-metadata">

**Author:** ![ywelsch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ywelsch/32/7751_2.png) [@ywelsch](https://discuss.elastic.co/u/ywelsch)\
**Post date:** [March 24, 2016, 10:33am UTC](https://discuss.elastic.co/t/insert-overwrite-table-hangs/45206/8 "2016-03-24T10:33:16Z")

</div>