# Query Elasticsearch with Readonlyrest plugin from Hive
**URL:** https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383
**Category:** Elasticsearch
**Tags:** es-hadoop
**Created:** [January 28, 2018, 11:37pm UTC](https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383 "2018-01-28T23:37:48Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@dzyubanv](https://discuss.elastic.co/u/dzyubanv)
#### Post date: [January 28, 2018, 11:37pm UTC](https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383/1 "2018-01-28T23:37:48Z")
I'm trying to configure and run Elasticsearch-5.6.3 with Readonlyrest plugin and Hadoop/Hive (es-hadoop-6.0 connector ) on RHEL and on different servers. Hadoop 2.7.3.2.6.3.0-235, Hive 1.2.1.100.2.6.3.0-235.
The readonlyrest plugin on Elasticserch side is set of jar files inside $ES\_HOME/plugins/readonlyrest folder and readonlyrest.yml file in $ES\_HOME/plugins/config folder.
I **successfully tested** querying Elasticsearch using hive external table, **when Readonlyrest plugin disabled**.
When I **enabled Readonlyrest plugin** , restarted Elasticsearch, then **execution** of "create external table ..." **failed**.
**Do I need to add some configuration property/variable, like es.xyz or anything else, to Hive External Table definition or to the current Hive session in order to let Hive table or/and es-hadoop connector know that Elasticsearch is running with enabled Readonlyrest plugin (or any other enabled plugin) ?**
Thanks in advance.
---
### Author:  [@james.baiera](https://discuss.elastic.co/u/james.baiera)
#### Post date: [January 29, 2018, 5:12am UTC](https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383/2 "2018-01-29T05:12:55Z")
Please avoid posting the same issue multiple times here. I understand that this forum does not have the same sort of response times as other forums on the site, but opening multiple threads for the same issue does not help. If you have more information on your issue, please bump/update the original post.
---
### Author:  [@dzyubanv](https://discuss.elastic.co/u/dzyubanv)
#### Post date: [January 30, 2018, 1:54am UTC](https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383/3 "2018-01-30T01:54:47Z")
I'm apology for the inconvenience James. Feel free to remove this post and I will update the original one. Thank you for your time, patience, support and help.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 27, 2018, 1:54am UTC](https://discuss.elastic.co/t/query-elasticsearch-with-readonlyrest-plugin-from-hive/117383/4 "2018-02-27T01:54:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.