# Select external table failed

**URL:** <https://discuss.elastic.co/t/select-external-table-failed/45308>\
**Category:** Elasticsearch\
**Created:** [March 24, 2016, 6:53am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308 "2016-03-24T06:53:36Z")\
**Posts on this page:** 6\
**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 24, 2016, 6:53am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/1 "2016-03-24T06:53:36Z")

</div>

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

any advice would be appreciatd.

Thanks  
Joe

---

<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, 7:09am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/2 "2016-03-24T07:09:33Z")

</div>

creating table scripts as follows, any comment would be appreciated:

CREATE EXTERNAL TABLE user01(id BIGINT, name STRING) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'  
TBLPROPERTIES('es.resource' = 'radio/artists','es.index.auto.create' = 'true','es.nodes'='192.168.112.172','es.port'='9200');

---

<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, 7:10am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/3 "2016-03-24T07:10:46Z")

</div>

if I change port from 9200 ro 9000, it turns out to be other error 🙂

hive\> select \* from user01;  
OK  
Failed with exception java.io.IOException:org.elasticsearch.hadoop.rest.EsHadoopInvalidRequest: [GET] on [] failed; server[192.168.112.172:9000] returned [404|Not Found:]  
Time taken: 0.122 seconds

---

<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, 9:32am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/4 "2016-03-24T09:32:24Z")

</div>

Can you post this into the "Hadoop and Elasticsearch" category please?

---

<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:58am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/5 "2016-03-24T09:58:25Z")

</div>

Ok, will paste it there, please close this one,

---

<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:03am UTC](https://discuss.elastic.co/t/select-external-table-failed/45308/6 "2016-03-24T10:03:34Z")

</div>