Fetching data from DB using logstash


(baddy) #1

I am trying to fetch data from Database.
I have field timedetail in database table,
this field is in format "dd-MMM-yy HH.mm.ss.SSSS a"
i want to add this field as @timestamp
when i used
filter{
date{
match=> ["timedetail", "dd-MMM-yy HH.mm.ss.SSSS a"
}
}

it gives dateparse error

how can i solve this?


(Magnus B├Ąck) #2

It's impossible to help without seeing an example timestamp. You might as well show a complete event.

When the date filter fails and tags the event with _dateparsefailure it logs a message describing the problem, so look in the Logstash log for clues.


(system) #3

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