# Field data is too large

**URL:** <https://discuss.elastic.co/t/field-data-is-too-large/54118>\
**Category:** Elasticsearch\
**Created:** [June 28, 2016, 6:53am UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118 "2016-06-28T06:53:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Radoslaw\_Wojtkiewicz](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Radoslaw\_Wojtkiewicz](https://discuss.elastic.co/u/Radoslaw_Wojtkiewicz)\
**Post date:** [June 28, 2016, 6:53am UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118/1 "2016-06-28T06:53:46Z")

</div>

I have a problem with sorting namely, sorting work but only for price field. When I try to sort by start\_date, end\_date, uid, cat title get the message about exceeding the limit:

`Data too large, the date for ["name of field here"] would be larger than the limit of [19798897459 / 18.4gb]]`

I do not know why this is happening code looks correct sample query for elastica looks like this:

Mapping:

```
"auctions": {
                "_all": { "enabled": false }, 
                "properties": {
                    "cat": { "store": true, "type": "long" }, 
                    "curr": { "index": "not_analyzed", "store": true, "type": "string" }, 
                    "end_date": { "store": true, "type": "long" }, 
                    "price": { "store": true, "type": "long" }, 
                    "start_date": { "store": true, "type": "long" }, 
                    "tcat": { "store": true, "type": "long" }, 
                    "title": { "store": true, "type": "string" }, 
                    "uid": { "store": true, "type": "long" }
                }
            }, 

```

/\_stats/fielddata?fields=\*

```
{
    "_shards": {
        "total": 10,
        "successful": 5,
        "failed": 0
    },
    "_all": {
        "primaries": {
            "fielddata": {
                "memory_size_in_bytes": 19466671904,
                "evictions": 0,
                "fields": {
                    "_id": {
                        "memory_size_in_bytes": 0
                    },
                    "cat": {
                        "memory_size_in_bytes": 0
                    },
                    "price": {
                        "memory_size_in_bytes": 3235221240
                    },
                    "title": {
                        "memory_size_in_bytes": 16231450664
                    }
                }
            }
        },
        "total": {
            "fielddata": {
                "memory_size_in_bytes": 19466671904,
                "evictions": 0,
                "fields": {
                    "_id": {
                        "memory_size_in_bytes": 0
                    },
                    "cat": {
                        "memory_size_in_bytes": 0
                    },
                    "price": {
                        "memory_size_in_bytes": 3235221240
                    },
                    "title": {
                        "memory_size_in_bytes": 16231450664
                    }
                }
            }
        }
    },
    "indices": {
        "allek": {
            "primaries": {
                "fielddata": {
                    "memory_size_in_bytes": 19466671904,
                    "evictions": 0,
                    "fields": {
                        "_id": {
                            "memory_size_in_bytes": 0
                        },
                        "cat": {
                            "memory_size_in_bytes": 0
                        },
                        "price": {
                            "memory_size_in_bytes": 3235221240
                        },
                        "title": {
                            "memory_size_in_bytes": 16231450664
                        }
                    }
                }
            },
            "total": {
                "fielddata": {
                    "memory_size_in_bytes": 19466671904,
                    "evictions": 0,
                    "fields": {
                        "_id": {
                            "memory_size_in_bytes": 0
                        },
                        "cat": {
                            "memory_size_in_bytes": 0
                        },
                        "price": {
                            "memory_size_in_bytes": 3235221240
                        },
                        "title": {
                            "memory_size_in_bytes": 16231450664
                        }
                    }
                }
            }
        }
    }
}

```

Any ideas what might cause this exception?

I should add that I've tried these solutions:

[FIELDDATA Data is too large](http://stackoverflow.com/questions/30811046/fielddata-data-is-too-large)

But the effect was even worse, then no query did not work as quickly.

For any help I will be extremely grateful!

---

<div class="post-metadata">

**Author:** ![ravitandur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ravitandur/32/4568_2.png) [@ravitandur](https://discuss.elastic.co/u/ravitandur)\
**Post date:** [June 28, 2016, 8:05am UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118/2 "2016-06-28T08:05:28Z")

</div>

> [@Radoslaw\_Wojtkiewicz](#):
>
> title

As per the field data, the title field is using ~15GB of heap.  
Can you please let me know your heap settings.  
Please enable doc\_values for title filed which will reduce the filed data memory pressure.

---

<div class="post-metadata">

**Author:** ![ravitandur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ravitandur/32/4568_2.png) [@ravitandur](https://discuss.elastic.co/u/ravitandur)\
**Post date:** [June 28, 2016, 8:09am UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118/3 "2016-06-28T08:09:17Z")

</div>

You are also hitting, field data circuit breaker which will be default to 60% of heap value.  
If you enable doc\_values to true for title field, the field date will be stored onto disk instead of heap.  
Please let me know if you need any further help.

---

<div class="post-metadata">

**Author:** ![Radoslaw\_Wojtkiewicz](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Radoslaw\_Wojtkiewicz](https://discuss.elastic.co/u/Radoslaw_Wojtkiewicz)\
**Post date:** [June 28, 2016, 8:25am UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118/4 "2016-06-28T08:25:35Z")

</div>

I`m not configure server for elasticsearch but could you tell me:

1. How I can get heap settings?
2. How enabled doc\_values for title field? (this error is not only for title , its for all fields)?

---

<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 5, 2017, 10:39pm UTC](https://discuss.elastic.co/t/field-data-is-too-large/54118/5 "2017-07-05T22:39:59Z")

</div>