# Not able to query a Hive ES table
**URL:** https://discuss.elastic.co/t/not-able-to-query-a-hive-es-table/59937
**Category:** Elasticsearch
**Tags:** es-hadoop
**Created:** [September 7, 2016, 3:02am UTC](https://discuss.elastic.co/t/not-able-to-query-a-hive-es-table/59937 "2016-09-07T03:02:48Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@vjk1688](https://discuss.elastic.co/u/vjk1688)
#### Post date: [September 7, 2016, 3:02am UTC](https://discuss.elastic.co/t/not-able-to-query-a-hive-es-table/59937/1 "2016-09-07T03:02:48Z")
Hi,
I am using Hadoop 2.6 , ElasticSearch 2.3.0 and Hadoop-ES 2.4.1
I have loaded data to a Hive-ES external table. The data got indexed in ElasticSearch and I am able to search.
But whenever I try to query the Hive-ES table I get the following error
Failed with exception java.io.IOException:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Can somebody provide a pointer please ?
---
### Author:  [@james.baiera](https://discuss.elastic.co/u/james.baiera)
#### Post date: [September 7, 2016, 10:09pm UTC](https://discuss.elastic.co/t/not-able-to-query-a-hive-es-table/59937/2 "2016-09-07T22:09:32Z")
> [@vjk1688](#):
>
> But whenever I try to query the Hive-ES table I get the following error
>
> Failed with exception java.io.IOException:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Could you provide a full stack trace? The IOException on it's own is not enough to help troubleshoot the problem. Thanks.
> [@vjk1688](#):
>
> Can somebody provide a pointer please ?
[0x3A28213A](https://xkcd.com/138/), Couldn't resist 😁
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:23pm UTC](https://discuss.elastic.co/t/not-able-to-query-a-hive-es-table/59937/3 "2017-07-06T13:23:20Z")