# Analyse stored data in the elastic cloud with analyzer "whitespace"

**URL:** <https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960>\
**Category:** Elasticsearch\
**Created:** [April 19, 2017, 10:52pm UTC](https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960 "2017-04-19T22:52:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dominik](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Dominik](https://discuss.elastic.co/u/Dominik)\
**Post date:** [April 19, 2017, 10:52pm UTC](https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960/1 "2017-04-19T22:52:02Z")

</div>

Hello,

I uploaded about 500 Keywords to the elastic cloud server. Each keyword can have a different amount of words from 1 up to 8. With each keyword I store the number of clicks as integer.

I want to use the whitespace analyzer to get the single words within a keyword.

Via Sense this request worked:

POST searchterm\_index/\_analyze  
{  
"analyzer": "whitespace",  
"text": "this is my keyword"  
}

The question is: How can I use the whitespace analyzer for the data which is already stored in the elastic search cloud (the 500 keywords)?

In the example above I have to send a text wich will be "whitespace" analyzed. An not optimal solution to solve my problem could be a request to the elastic search cloud to get all 500 keywords and then the script analyze the 500 keywords in a loop with the whitespace analyzer. This seems not the perfect solution and so I'm wondering whether there is a smarter way?

Best  
Dominik

---

<div class="post-metadata">

**Author:** ![matschaffer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matschaffer/32/95396_2.png) [@matschaffer](https://discuss.elastic.co/u/matschaffer)\
**Post date:** [April 20, 2017, 6:40am UTC](https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960/2 "2017-04-20T06:40:51Z")

</div>

Hi Dominik,

I've bumped this to the Elasticsearch forum since the question deals mainly with ES itself.

I believe your only option there would be to reindex the data into an index with a new mapping that includes just the whitespace analyzer on whatever field you're trying to query.

Though could be folks in this forum know of other tricks or good references for you.

---

<div class="post-metadata">

**Author:** ![Dominik](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Dominik](https://discuss.elastic.co/u/Dominik)\
**Post date:** [April 20, 2017, 4:46pm UTC](https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960/3 "2017-04-20T16:46:59Z")

</div>

Ok, but how can I get all (re)indexed whitespaces data? Let's assume I have to keywords. Each of the keywords contains of 3 words. So I should have 6 words in the whitespace index. How can I get these 6 words with one query?

---

<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:** [April 23, 2017, 4:47pm UTC](https://discuss.elastic.co/t/analyse-stored-data-in-the-elastic-cloud-with-analyzer-whitespace/82960/4 "2017-04-23T16:47:16Z")

</div>

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