# How to set "ignore\_above" : 256 to higher value while using python elasticsearch client? **URL:** \ **Category:** Kibana\ **Created:** [November 13, 2020, 12:14pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338 "2020-11-13T12:14:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Post date:** [November 13, 2020, 12:14pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/1 "2020-11-13T12:14:48Z")
I am using python ES client to index data into my ES... I have a column which is more than 256 characters. when I create a data table viz. in kibana I get no results message if I include that lengthy column. Below is the code I am using to index and followed are the screenshots. ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/a/5af6df473eb17f7185e9df329d754deb3a1f7e62.png) In the below picture, I have disabled the lengthy column hence getting the result- ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c306c82bdf7190e7b1098b6c259a03c246a6fa03.png) In the below picture, I have enabled the lengthy column hence NOT getting the result- ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/1/71fd64f000a519a3d9a3021fb5a98aed21c3a990.png) Below is my index mapping- ```auto { "mappings": { "_doc": { "properties": { "author": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "story": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "story number": { "type": "long" }, "title": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "topic": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } } } } } } ``` Thanks in advance 😀 ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [November 13, 2020, 1:40pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/2 "2020-11-13T13:40:50Z")
hello @vidhyadhara `ignore_above` affects how data is indexed - [https://www.elastic.co/guide/en/elasticsearch/reference/current/ignore-above.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/ignore-above.html) it can be changed by altering the mapping - [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-put-mapping.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-put-mapping.html) Unfortunately this means it can't be changed on a per client basis. Thanks, Matt ---
**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Post date:** [November 13, 2020, 1:55pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/3 "2020-11-13T13:55:54Z")
Hello @mattkime, So there isn't any work to have a longer text in data table?? ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [November 13, 2020, 2:22pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/4 "2020-11-13T14:22:31Z")
@vidhyadhara You can have longer text in a data table but it needs to be stored. ---
**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Post date:** [November 24, 2020, 2:10pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/5 "2020-11-24T14:10:56Z")
What is the maximum length of data that can be displayed in a data table column? I did change the "ignore\_above" value to 999999999 (which I found to be maximum allowed), still not able to display all the data. Below is the screen shot of my index mapping- ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/4/e4d5485f3a40603af01236d7394f8b742b97dd7a.png) what or how I have to alter my index mapping to display the lengthy data. ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [November 24, 2020, 2:26pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/6 "2020-11-24T14:26:06Z")
@vidhyadhara Are you looking at newly indexed data? `ignore_above` is applied at time of index. ---
**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Post date:** [November 24, 2020, 3:02pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/7 "2020-11-24T15:02:51Z")
@mattkime oh, I changed the mapping using kibana dev tools after the data is indexed. How to index with large value for **ignore\_above**?? I am indexing data from SQL database to Elasticsearch using python. ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [November 24, 2020, 3:14pm UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/8 "2020-11-24T15:14:21Z")
You need to reimport your data. Hopefully thats not too burdensome for you. If it is, you might import to a new index to verify you have the functionality you need. ---
**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\ **Post date:** [November 25, 2020, 6:37am UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/9 "2020-11-25T06:37:38Z")
Hello @mattkime, Beautiful... All I was missing was reimporting of the data. Thank you so much. 😀 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 23, 2020, 6:37am UTC](https://discuss.elastic.co/t/how-to-set-ignore-above-256-to-higher-value-while-using-python-elasticsearch-client/255338/10 "2020-12-23T06:37:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.