Select external table failed

Elastic Stack Elasticsearch
1

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

2

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');

3

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

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

4

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

5

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