# Logstash \> ES field convert issue

**URL:** <https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158>\
**Category:** Kibana\
**Created:** [March 20, 2019, 1:52pm UTC](https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158 "2019-03-20T13:52:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob\_Price](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rob_price/32/42425_2.png) [@Rob\_Price](https://discuss.elastic.co/u/Rob_Price)\
**Post date:** [March 20, 2019, 1:52pm UTC](https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158/1 "2019-03-20T13:52:32Z")

</div>

I'm successfully importing SQL query data into ES via logstash - however, a numerical field is being processed as a string; so I have added a filter-mutate-convert into the pipeline to change the field to an integer; looking at the index mapping, this seems successful as it is now processed as "long" however, in the index pattern area, the field options now only give me the option of URL (in addition to the original string)?

The same is true of processing the field as a float; index pattern options for the field are limited to string and URL?

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [March 20, 2019, 2:19pm UTC](https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158/2 "2019-03-20T14:19:07Z")

</div>

Hmm, have you tried refreshing the index pattern in Kibana?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/c/bc22d040e03b4811795328c4d274b7b00aa24aa9.png)

---

<div class="post-metadata">

**Author:** ![Rob\_Price](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rob_price/32/42425_2.png) [@Rob\_Price](https://discuss.elastic.co/u/Rob_Price)\
**Post date:** [March 20, 2019, 2:28pm UTC](https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158/3 "2019-03-20T14:28:22Z")

</div>

Hi lukas,

Yes, everything refreshed - for clarity:  
raw data:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/6/2651852bcdb37671e22f0b5c2bb2a60179c6d406.png)

pipeline:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/1/014aa90e42429d3b055c50a2da074e2462e7d57d.png)

Mapping:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/2/82955b1826ce24f1db037a6c9e0e12518d603da0.png)

Index Pattern:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/2/02817ea37b7ed9787aaffb3b9f1858852bad70ab.png)

---

<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 17, 2019, 2:28pm UTC](https://discuss.elastic.co/t/logstash-es-field-convert-issue/173158/4 "2019-04-17T14:28:34Z")

</div>

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