Need help to convert into date from string

Elastic Stack Kibana
1

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

2

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.

3

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

Manu

4

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

5

Thanks, I'll try with that.

6

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