# Logstash를 통한 csv import 오류

**URL:** https://discuss.elastic.co/t/logstash-csv-import/236967
**Category:** 한국어 질문 및 토론
**Created:** [June 13, 2020, 8:47am UTC](https://discuss.elastic.co/t/logstash-csv-import/236967 "2020-06-13T08:47:34Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Jun.8](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jun.8/32/68749_2.png) [@Jun.8](https://discuss.elastic.co/u/Jun.8)
#### Post date: [June 13, 2020, 8:47am UTC](https://discuss.elastic.co/t/logstash-csv-import/236967/1 "2020-06-13T08:47:34Z")

</div>

안녕하세요. 제가 geo\_point 데이터를 2개 쓰고 싶어서 아래와 같이 작성하였는데요. logstash를 실행하면 elasticsearch에 잘 전달한 것 같은데 kibana를 보면 데이터가 들어와있지 않습니다. 어떤 오류인지 모르겠습니다.

 ![스크린샷 2020-06-13 오후 5.47.16](https://us1.discourse-cdn.com/elastic/original/3X/1/4/1402c060ae332ca3559319f7eb983cc321b408d0.png) ![스크린샷 2020-06-13 오후 5.46.50](https://us1.discourse-cdn.com/elastic/original/3X/2/6/263153d701266b4ffcd34316d3639b3014455b2e.png) zpRQtoUy8muYIGIyxpu5Fh.png)

```
input {
  file {
    path => "/Users/user/Downloads/coronavirusdataset_20200601/PatientRoute.csv"
    start_position => "beginning"
    sincedb_path => "/dev/null"    
  }
}
filter {
  csv {
      separator => ","
      columns => ["patient_id","global_num","date","province","city","type","lat","lon","city_lat","city_lon"]
  }
  mutate {convert => ["lat", "float"]}
  mutate {convert => ["lon", "float"]}
  mutate {convert => ["city_lat", "float"]}
  mutate {convert => ["city_lon", "float"]}
  mutate {convert => ["global_num", "float"]}
  mutate {
    add_field => {"[location-specific][lat]" => "%{lat}"}
    add_field => {"[location-specific][lon]" => "%{lon}"}
    add_field => {"[location-city][city_lat]" => "%{city_lat}"}
    add_field => {"[location-city][city_lon]" => "%{city_lon}"}
  }
  mutate {
    convert => {"[location-specific][lat]" => "float"}
    convert => {"[location-specific][lon]" => "float"}
    convert => {"[location-city][city_lat]" => "float"}
    convert => {"[location-city][city_lon]" => "float"}
  }
  
output {  
    elasticsearch {
        hosts => ["http://localhost:9200"]
        index => "map_test"
        user => "elastic"
        password => "비밀번호"
    }
    stdout { codec => rubydebug {metadata => true}}
    stdout { codec => dots }
}

```

kibana dev tools로 미리 index 설정해두고 logstash 실행시켰습니다.

```
PUT map_test/_mapping
{
  "properties": {
    "location-specific": {
      "type": "geo_point"
    },
    "location-city": {
      "type": "geo_point"
    }
  }
}
```

---

<div class="post-metadata">

### Author: ![Jun.8](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jun.8/32/68749_2.png) [@Jun.8](https://discuss.elastic.co/u/Jun.8)
#### Post date: [June 13, 2020, 9:20am UTC](https://discuss.elastic.co/t/logstash-csv-import/236967/2 "2020-06-13T09:20:20Z")

</div>

logstash 실행시 여러 메세지가 빠르게 지나가서 겨우 잡았는데요. 다음과 같은 에러 메세지가 나오더군요.. 무엇을 의미하는지 잘 모르겠습니다.ㅠ

`[2020-06-13T18:09:19,549][WARN][logstash.outputs.elasticsearch][main][502f63f93cc9a9a288e0b68fa196048a37c905498f14c83e1504f515a21b5a43] Could not index event to Elasticsearch. {:status=>400, :action=>["index", {:_id=>nil, :_index=>"map_test", :routing=>nil, :_type=>"_doc"}, #<LogStash::Event:0x2d202e20>], :response=>{"index"=>{"_index"=>"map_test", "_type"=>"_doc", "_id"=>"dHjwrHIBhdLkyYcqwj4c", "status"=>400, "error"=>{"type"=>"mapper_parsing_exception", "reason"=>"failed to parse field [location-city] of type [geo_point]", "caused_by"=>{"type"=>"parse_exception", "reason"=>"field must be either [lat], [lon] or [geohash]"}}}}}`

---

<div class="post-metadata">

### Author: ![kimjmin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kimjmin/32/15223_2.png) [@kimjmin](https://discuss.elastic.co/u/kimjmin)
#### Post date: [June 19, 2020, 12:28am UTC](https://discuss.elastic.co/t/logstash-csv-import/236967/3 "2020-06-19T00:28:52Z")

</div>

location-city 필드가

```auto
location-city : { city_lat: 0.0, city_lon:0.0 }

```

이렇게 되어 있는데, geo\_point 필드로 쓰시려면

```auto
location-city : { lat: 0.0, lon: 0.0 } 

```

이렇게 하셔야 합니다.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 17, 2020, 12:28am UTC](https://discuss.elastic.co/t/logstash-csv-import/236967/4 "2020-07-17T00:28:54Z")

</div>

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