Select external table failed


(Joe Yang) #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


(Joe Yang) #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');


(Joe Yang) #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


(Yannick Welsch) #4

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


(Joe Yang) #5

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


(Yannick Welsch) #6