ElasticSearch Logstash导入CSV文件(六)

# 工作目录
lixin-macbook:bin lixin$ pwd
/Users/lixin/Developer/elastic-search/logstash-7.10.0/bin

input {
  file {
    path => "/Users/lixin/Developer/elastic-search/work/movies.csv"
    start_position => "beginning"
    sincedb_path => "/dev/null"
  }
}
filter {
  csv {
    separator => ","
    columns => ["id","content","genre"]
  }

  mutate {
    split => { "genre" => "|" }
    remove_field => ["path", "host","@timestamp","message"]
  }

  mutate {

    split => ["content", "("]
    add_field => { "title" => "%{[content][0]}"}
    add_field => { "year" => "%{[content][1]}"}
  }

  mutate {
    convert => {
      "year" => "integer"
    }
    strip => ["title"]
    remove_field => ["path", "host","@timestamp","message","content"]
  }

}
output {
   elasticsearch {
     hosts => "http://localhost:9200"
     index => "movies"
     document_id => "%{id}"
   }
  stdout {}
}

# logstash工作目录
lixin-macbook:bin lixin$ pwd
/Users/lixin/Developer/elastic-search/logstash-7.10.0/bin

# 导入数据
lixin-macbook:bin lixin$ ./logstash -f /Users/lixin/Developer/elastic-search/work/logstash.conf