剛上手ELK,查了一兩天資料,在logstash的filter里對日期欄位做轉換,無論怎樣都不成功,大神幫忙看看是怎么回事,感謝!
Customer_No,TransDate,Pro_No,Seq_No,Trans_Amount
108245579,20190325201822,1178,1206,10
input
{
file{
path => ["/csv/*.csv"]
start_position => "beginning"
}
}
filter{
csv{
separator => ","
columns => [" Customer_No"," TransDate"," Pro_No"," Seq_No"," Trans_Amount"]
}
mutate{
convert => {
"Customer_No" => "string"
"TransDate" => "string"
"Pro_No" => "string"
"Trans_Amount" => "float"
}
}
date{
timezone => "Asia/Shanghai"
match => ["TransDate","yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss"]
target => "TransDate"
}
}
output{
elasticsearch{
hosts => ["elasticsearch:9200"]
index => "transaction"
}
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/70908.html
標籤:分布式計算/Hadoop
下一篇:隨筆
