Kibana Ingest pipeline Convert String to Date?

Elastic Stack Kibana
1

  1. Installed elastic-agent on the server and Collect Custom Log Data

  2. I was Create a pipeline in Kibana (Stack Management -> Ingest pipelines)

  3. And "Message" Field -> Split Data (Success)

How can I Convert String Field to Date Type in "Manage processor"?

  • "Time" Field is String

image
image694×443 22 KB

2

Check the Date Processor

image
image877×965 62.8 KB

1 Like
3

I set it like this

image
image718×559 35.8 KB

But.... I get this Error

image
image1274×95 7.61 KB

4

Probably because the string 2022-09-08 00:09:12.141 does not match the ISO8601 date format.

Try to use this in the format yyyy-MM-dd HH:mm:ss.SSS

2 Likes
5

After changing the settings "ISO8601 -> yyyy-MM-dd HH:mm:ss.SSS" (Success!!!)

image
image1537×272 31.1 KB

But column type Looks like String....

How can I Convert this type? (String -> Date)

6

It is the mapping in elasticsearch, only way to change it is creating a new index.

7

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