Logstash > ES field convert issue

Elastic Stack Kibana
1

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?

2

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

image
image.png1120×378 42.5 KB

3

Hi lukas,

Yes, everything refreshed - for clarity:
raw data:
image

pipeline:
image

Mapping:
image

Index Pattern:
image

4

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