We have elasticsearch 6.5.4 version and Cloudera 5.4.7-1 version. We installed elasticsearch-hadoop-2.1.1.jar to connect between hdfs and elasticsearch. Then the hive table below were created to fetch the data from elasticsearch.
CREATE EXTERNAL TABLE TEST_ES_TBL ( st string) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.nodes' = '10.51.29.105', 'es.port' = '9200', 'es.resource' = 'test/docs', 'es.mapping.names' = 'st: str', 'es.index.auto.create'='true');
But it gives the error like that;
java.io.IOException: org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Client-only routing specified but no client nodes with HTTP-enabled were found in the cluster...
We also set the "es.nodes.client.only" = "true" but nothing happens. Can you help us to solve the problem, please? What is the point we miss?
Any help would be appreciated. Thanks.