Select external table failed

(Joe Yang) #1

hive> select * from user01 limit 5;
Failed with exception Connection error (check network and/or proxy settings)- all nodes failed; tried [[]]
Time taken: 0.206 seconds

any advice would be appreciatd.


(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','' = 'true','es.nodes'='','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;
Failed with exception [GET] on [] failed; server[] 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