# Rollup Jobs and Limitations / Data Types

**URL:** <https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728>\
**Category:** Elasticsearch\
**Created:** [July 27, 2020, 9:50am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728 "2020-07-27T09:50:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![michaelpietzsch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michaelpietzsch/32/72828_2.png) [@michaelpietzsch](https://discuss.elastic.co/u/michaelpietzsch)\
**Post date:** [July 27, 2020, 9:50am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728/1 "2020-07-27T09:50:22Z")

</div>

Hi Guys,

I'm new to rollup jobs and I wanted to ask your opinion on some of the issues I'm encountering.

Question One: How to handle different data types such as IP

Here's my way of seeing it: Rollup jobs have to main components: the Metrics Fields which contain everything that can be condensed and manipulated basically floats and longs. And the Terms Fields which is everything else but only Keyword and Text. How does one handle stuff like IP or GEO IP Data types? Do some sort of conversion internally and save a duplicate as a string to be able to roll it up later on?

Question Two:  
Sometimes I get the error message: "must be aggregatable across all indices, but is not" how can this happen? Can it have something to do with my ILM policy? I do an index rollover when I reach a certain size. This leads me to the question, do you guys have any special tips on how to combine this with index rollovers? Is pointing the index\_pattern to the index alias name a good way to go about this.

With kind Regards  
Michael

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 27, 2020, 10:28am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728/2 "2020-07-27T10:28:50Z")

</div>

Welcome to our community! 😃 We aren't all guys though 🙂

On a conceptual level, the IP/location would be considered a "term", in that it's a unique identifier you want to attach the summarised metrics to. You should be able to run the rollup on it though, as per the examples on querying the field in the [docs here](https://www.elastic.co/guide/en/elasticsearch/reference/current/ip.html) (note, I haven't tried this myself).

> [@michaelpietzsch](#):
>
> Sometimes I get the error message: "must be aggregatable across all indices, but is not" how can this happen?

Perhaps sharing more info, the full error, the rollup definition, etc, might help us identify the cause?

---

<div class="post-metadata">

**Author:** ![michaelpietzsch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michaelpietzsch/32/72828_2.png) [@michaelpietzsch](https://discuss.elastic.co/u/michaelpietzsch)\
**Post date:** [July 27, 2020, 11:18am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728/3 "2020-07-27T11:18:23Z")

</div>

@warkolm Thanks for welcoming me! I am sorry i didn't ment to not include all genders...

I took a deeper look and IP datatypes are not shown to add terms... soo..

---

<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:** [August 24, 2020, 11:18am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728/4 "2020-08-24T11:18:33Z")

</div>

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