# Cloudera Hive - Google Cloud Elasticsearch Instance

**URL:** <https://discuss.elastic.co/t/cloudera-hive-google-cloud-elasticsearch-instance/202067>\
**Category:** Elasticsearch\
**Created:** [October 2, 2019, 10:10pm UTC](https://discuss.elastic.co/t/cloudera-hive-google-cloud-elasticsearch-instance/202067 "2019-10-02T22:10:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hs\_Kishore](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hs_kishore/32/52575_2.png) [@Hs\_Kishore](https://discuss.elastic.co/u/Hs_Kishore)\
**Post date:** [October 2, 2019, 10:10pm UTC](https://discuss.elastic.co/t/cloudera-hive-google-cloud-elasticsearch-instance/202067/1 "2019-10-02T22:10:00Z")

</div>

Hi,

I am using cloudera vm instance to load data into elasticsearch.  
The hive is from clourdera vm instance and elasticsearch is installed in an google cloud vm instance. The same setup was working about a month ago and doesn't now.

HIVE:  
create external table esl\_sales\_distinct(name STRING, state STRING, country STRING, zip INT, territory STRING, amt\_aug2018aug2019 FLOAT, amt\_jan2019july2019 FLOAT, amt\_2018 FLOAT, company STRING, status STRING, location STRING) stored by 'org.elasticsearch.hadoop.hive.EsStorageHandler' tblproperties ('es.resource'='sales\_distinct/\_doc', 'es.index.auto.create'='true', 'es.nodes'='x.x.x.x.', 'es.port'='9200', 'es.net.http.auth.user'='elastic', 'es.net.http.auth.pass'='elastic', 'es.nodes.wan.only'='true');

the above fails: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible or when targeting a WAN/Cloud instance without the proper setting 'es.nodes.wan.only'

whereas the curl command works absolutely fine:  
curl -u elastic:elastic -H "Content-Type: application/json" -XPUT '[http://x.x.x.x:9200/sales\_distinct](http://x.x.x.x:9200/sales_distinct)' -d '  
{  
"settings" : {  
"number\_of\_shards" : 1,  
"number\_of\_replicas" : 0  
},  
"mappings" : {  
"properties" : {  
"location" : {  
"type" : "geo\_point"  
}  
}  
}  
}'

Output: {"acknowledged":true,"shards\_acknowledged":true,"index":"sales\_distinct"}

Am I missing any TBLPROPERTIES? I mostly believe its the TBLPROPERTIES

Thanks.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 30, 2019, 10:10pm UTC](https://discuss.elastic.co/t/cloudera-hive-google-cloud-elasticsearch-instance/202067/2 "2019-10-30T22:10:03Z")

</div>

Closed on October 30, 2019, 10:10pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.