# \[hadoop\] Multiple indexes setting for 'es.resource'

**URL:** <https://discuss.elastic.co/t/hadoop-multiple-indexes-setting-for-es-resource/20100>\
**Category:** Elasticsearch\
**Created:** [October 7, 2014, 2:03am UTC](https://discuss.elastic.co/t/hadoop-multiple-indexes-setting-for-es-resource/20100 "2014-10-07T02:03:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mungeol\_Heo](https://avatars.discourse-cdn.com/v4/letter/m/dec6dc/32.png) [@Mungeol\_Heo](https://discuss.elastic.co/u/Mungeol_Heo)\
**Post date:** [October 7, 2014, 2:03am UTC](https://discuss.elastic.co/t/hadoop-multiple-indexes-setting-for-es-resource/20100/1 "2014-10-07T02:03:56Z")

</div>

Hi,

I have a problem with 'es.resource' configuration for including multiple  
indexes.

The hive table I created is like below

CREATE EXTERNAL TABLE test  
(  
date timestamp,  
clientip string,  
request string  
)  
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'  
TBLPROPERTIES  
(  
'es.resource' = 'apache-2014.09.29/apache-access',  
-- or  
-- 'es.resource' = 'apache-2014.09.30/apache-access',  
'es.mapping.names' = 'date:@timestamp [https://github.com/timestamp](https://github.com/timestamp)'  
);

and I used 'select count(_) from test;' which is a hive query to count the  
total number of rows of the table.  
the result is same with ES count.  
the count result are 1454536 and 215564 for each apache-2014.09.29 and  
apache-2014.09.30 index  
then, I changed 'es.resource' = 'apache-2014.09.29/apache-access' to  
'es.resource' = 'apache-2014.09._/apache-access' or  
'es.resource' = 'apache-2014.09.29,apache-2014.09.30/apache-access'  
for including multiple indexes.  
and I used 'select count(\*) from test;' again to count the total number of  
documents of the indexes,  
but the result is different with ES count.  
the count result is 2919161 which should be 1670100 (1454536 + 215564).

## any help?

environmental information

- centos base 6.4 64-bit / java version "1.7.0\_55"
- CDH-5.1.2-1.cdh5.1.2.p0.3
- hive 0.12.0
- elasticsearch-hadoop-2.0.1
- 3 nodes' hadoop and es cluster

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/12e1d78b-9f6f-491a-87d8-5249c45b9812%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/12e1d78b-9f6f-491a-87d8-5249c45b9812%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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:** [July 6, 2017, 12:58am UTC](https://discuss.elastic.co/t/hadoop-multiple-indexes-setting-for-es-resource/20100/2 "2017-07-06T00:58:01Z")

</div>