# How to use execution hint in kibana

**URL:** <https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471>\
**Category:** Kibana\
**Created:** [May 28, 2018, 6:49am UTC](https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471 "2018-05-28T06:49:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kapoorvarun23](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kapoorvarun23/32/31641_2.png) [@kapoorvarun23](https://discuss.elastic.co/u/kapoorvarun23)\
**Post date:** [May 28, 2018, 6:49am UTC](https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471/1 "2018-05-28T06:49:13Z")

</div>

I am trying to create Data table visualization on Kibana having 5 aggregrations but request gets timed out because of high cardinality of 2 terms.

I made same query on elastic with execution\_hint as map. Query is 10 times faster than default execution\_hint.

I want to know how can i acheive execution\_hint as map in Kibana. Currently my Kibana version is 4.5

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [May 28, 2018, 7:36am UTC](https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471/2 "2018-05-28T07:36:41Z")

</div>

Hi Varun,

you can actually add to the JSON of the aggregation using the "JSON input" under Advanced when editing the terms aggregation. That JSON will be merged into the JSON for the terms aggregation, so you can use it to set the `execution_hint`:

![screenshot-20180528-093423](https://us1.discourse-cdn.com/elastic/original/3X/f/0/f09124dc59c26f3ec9bf4460f07771d185c27d4d.png)

Though not sure if that possibility was already there in 4.5, since that version is quite outdated and not supported anymore. If the advanced JSON input does not exist at that time, updating to a more recent version should solve the issue.

Cheers,  
Tim

---

<div class="post-metadata">

**Author:** ![kapoorvarun23](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kapoorvarun23/32/31641_2.png) [@kapoorvarun23](https://discuss.elastic.co/u/kapoorvarun23)\
**Post date:** [May 28, 2018, 8:19am UTC](https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471/3 "2018-05-28T08:19:56Z")

</div>

Thanks @timroes. It helped 🙂

---

<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:** [June 25, 2018, 8:19am UTC](https://discuss.elastic.co/t/how-to-use-execution-hint-in-kibana/133471/4 "2018-06-25T08:19:57Z")

</div>

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