# Data Table show all Terms as Missing when term length is too big

**URL:** https://discuss.elastic.co/t/data-table-show-all-terms-as-missing-when-term-length-is-too-big/190925
**Category:** Kibana
**Created:** [July 17, 2019, 8:51am UTC](https://discuss.elastic.co/t/data-table-show-all-terms-as-missing-when-term-length-is-too-big/190925 "2019-07-17T08:51:01Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Gregory\_leguenec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gregory_leguenec/32/45582_2.png) [@Gregory\_leguenec](https://discuss.elastic.co/u/Gregory_leguenec)
#### Post date: [July 17, 2019, 8:51am UTC](https://discuss.elastic.co/t/data-table-show-all-terms-as-missing-when-term-length-is-too-big/190925/1 "2019-07-17T08:51:01Z")

</div>

Hi Everyone,

I have **String** fields from 200 char to 2000 char, however, when i try to simply display them in a data table, the short ones seems to appear, but 99% of the rest, it's just display _missing_.

 ![04](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8e957ff26c3db3d9956c8303fb62a450568793b6.png)

Is there is any field size limit for the data table visualisation ? They all appear without issue in the Discover section

 ![59](https://us1.discourse-cdn.com/elastic/original/3X/2/8/2871c83d4f01025dace1a333e985be8324cc4eb8.png)

Kibana version: **6.7.0**

Thanks a lot in advance

---

<div class="post-metadata">

### Author: ![Tobymaro](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@Tobymaro](https://discuss.elastic.co/u/Tobymaro)
#### Post date: [July 18, 2019, 5:21am UTC](https://discuss.elastic.co/t/data-table-show-all-terms-as-missing-when-term-length-is-too-big/190925/2 "2019-07-18T05:21:16Z")

</div>

Hi this issue is related to mapping

You can see mapping for your index in this way:

`GET _mapping/index_name`

There are fields keyword type:

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

```

So basically keyword is used for visualization. And if length is grater than 256 symbols you can't see it because it's not indexed.

So you just need to change this value. For this you can add additional template.

```
PUT /_template/stat_1
{  
   "index_patterns":"stats-*",
   "order":1,
   "mappings":{  
      "stat":{  
         "properties":{  
            "long_string_field":{  
               "type":"text",
               "fields":{  
                  "keyword":{  
                     "type":"keyword",
                     "ignore_above":512000
                  }
               }
            }
         }
      }
   }
}
```

---

<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 15, 2019, 5:21am UTC](https://discuss.elastic.co/t/data-table-show-all-terms-as-missing-when-term-length-is-too-big/190925/3 "2019-08-15T05:21:29Z")

</div>

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