无法在logstash中解析日期 [英] Can't parse date in logstash

问题描述

我需要解析我的日期，它给我一个错误。

I need to parse my Date and it gives me an error.

input {  
  file {
    path => "/home/osboxes/ELK/logstash/data/data.csv"
    start_position => "beginning"    
  }
}
filter {  
  csv {
      separator => ","
      columns => ["Date","Open","High","Low","Close","Volume","Adj Close"]
  }


  mutate {convert => ["High", "float"]}
  mutate {convert => ["Open", "float"]}
  mutate {convert => ["Low", "float"]}
  mutate {convert => ["Close", "float"]}
  mutate {convert => ["Volume", "float"]}
}

output {  
    elasticsearch {
        action => "index"
        hosts => "localhost:9200"
        index => "stock"
        workers => 1
    }
    stdout {}
}

数据。 csv当我正在读这是这样的：

The data.csv when I'm reading this is like this:

Date,Open,High,Low,Close,Volume,Adj Close
2015-04-02,125.03,125.56,124.19,125.32,32120700,125.32
2015-04-01,124.82,125.12,123.10,124.25,40359200,124.25

我在哪里丢失？感谢提前。

Where am I missing? Thanks in advance.

我的logstash终端只能说：

My logstash terminal only say this:

$ bin/logstash -f /home/osboxes/ELK/logstash/logstash.conf 
Settings: Default pipeline workers: 2
Pipeline main started

推荐答案

向筛选器添加日期语句：

Add a date statement to the filter:

date {
    match => [ "Date", "YYYY-MM-dd" ]
}

这篇关于无法在logstash中解析日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！