Need help to convert into date from string

pingmehere · January 12, 2018, 6:14pm

Hi there,
I'm importing sql data into ES through some 3rd party software. While importing data from database to ES, it taking as string but I want this data as date datatype. May I know how to convert in Kibana uploaded data.

Thanks
Manu

Brandon_Kobel · January 12, 2018, 8:00pm

Hey @pingmehere you could use Kibana's Scripted Fields to convert the strings into dates, but it'll be much less performant than doing so on ingest.

pingmehere · January 12, 2018, 8:12pm

Thanks.
Is there any other way to convert with high and good performance.

Manu

Brandon_Kobel · January 12, 2018, 8:33pm

@pingmehere you could use the Reindex API in Elasticsearch to execute a script that converts to the Date field.

pingmehere · January 12, 2018, 9:30pm

Thanks, I'll try with that.

system · February 9, 2018, 9:30pm

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