# Trying to use Aggregate, "Fielddata is disabled on text fields by default. Set fielddata=true"

**URL:** <https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259>\
**Category:** Elasticsearch\
**Created:** [March 21, 2019, 7:49am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259 "2019-03-21T07:49:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Noctis17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/noctis17/32/41656_2.png) [@Noctis17](https://discuss.elastic.co/u/Noctis17)\
**Post date:** [March 21, 2019, 7:49am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259/1 "2019-03-21T07:49:44Z")

</div>

ElasticSearch version: 6.6  
Language: PHP

Hello and good day! I'm using Laravel PHP Framework and ElasticSearch as our database / search engine.

In my Index, I'm trying to get a list of Authors who had produced the most Articles, here's my parameters:

```
$params = [
		'index' => 'mmi.webs',
		'type'	=> '_doc',
		"from" => '0', //default 0
		"size" => '10', //default 10
		'body'	=> [
		    'aggs' => [
				'authors' => [
					'terms' => [
						'field' => 'author_id',
						'size' => 25,
						'order' => ['_term' => 'asc']
					]
				],
			]
		]
	];

```

But unfortunately it returns this error according to my **author\_id** , ""Fielddata is disabled on text fields by default. Set fielddata=true".

I've searched for different solutions, and some said turn on the "keyword" something, but according to the mapping of my index, keywords are already enabled

```
"author_id" : {
        "type" : "text",
        "fields" : {
          "keyword" : {
            "type" : "keyword",
            "ignore_above" : 256
          }
        }
      },

```

So why is it still not working?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 21, 2019, 8:40am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259/2 "2019-03-21T08:40:48Z")

</div>

Run your aggregation on `author_id.keyword` instead.

---

<div class="post-metadata">

**Author:** ![Noctis17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/noctis17/32/41656_2.png) [@Noctis17](https://discuss.elastic.co/u/Noctis17)\
**Post date:** [March 21, 2019, 9:20am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259/3 "2019-03-21T09:20:22Z")

</div>

hello sir @dadoonet, thank you for the fast response!

may I know how to run my aggregation on **author\_id.keyword**? is it supposed to look like this?

```
'aggs' => [
				'authors' => [
					'terms' => [
						'field' => 'author_id.keyword',
						'size' => 25,
						'order' => ['_term' => 'asc']
					]
				],
			]

```

If it is correct, I've started retrieving buckets!

Again, thank you very much, appreciate it! 😃

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 21, 2019, 9:39am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259/4 "2019-03-21T09:39:10Z")

</div>

> [@Noctis17](#):
>
> is it supposed to look like this?

Yes.

---

<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 18, 2019, 9:39am UTC](https://discuss.elastic.co/t/trying-to-use-aggregate-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true/173259/5 "2019-04-18T09:39:16Z")

</div>

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