I have added the date format as u told me then run the config file it still showing the same date type string please check the attached screenshot ![Date%20String|690x407](upload://bWcwOu6aLJfyhRZjtVrkK1rOOOz.jpeg)
Im sorry @Syed.Ubaid I have no idea by now, but I will keep trying to fix your problem.
Thank you
Hi,
What have you in your template index for this field ?
Date : {
"type": "date",
"format": "MM/DD/YYYY HH:mm"
}
How can we use template index and can we do this through mapping? any screenshot or links ?
Please see the attached file, the error occured when update date field from existing index. please look into it.
any update
@dgonzalezp dgonzalezp
Hi @Syed.Ubaid
Sorry, yesterday I was a little bit busy and I couldnt help you.
I can change my fields in date format to srtring in this section:
Can you did it from string to date?
I have string value field you have date value field please check the attached screenshot
timestamp is by default in date format the problem is that i want to convert the date string into date format so i would do aggregation on date column
now see this screenshot timestamp is coming in date format
i want the date column type into date format which is by default is coming into string format..What kind of input/filter/output have you in your logstash?
Can you share all these files? I want to see them, maybe the problem is in there.
input {
file {
path => "D:/kibanaproject/testing.csv"
start_position => "beginning"
sincedb_path => "NUL"
}
}
filter {
csv {
separator => ","
columns => ["Date","MobileNo","Msg","ServiceId","SMS","wsResponse","AKNMsgId","MMMsgId","AmountCharged"]
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "test-%{+dd.MM.YYYY}"
}
stdout {codec => json_lines }
}
this is my config file
mutate {
convert => { "Date" => "date" }
}
}
when i put this filter it does not parse the data.
Try this:
filter {
csv {
separator => ","
columns => ["Date","MobileNo","Msg","ServiceId","SMS","wsResponse","AKNMsgId","MMMsgId","AmountCharged"]
convert => { "Date" => "date" }
}
}
i tried this but error in logstash service start and stop
it works logstash parse the data but date format still showing in string