Unable to load csv file through logstash

I am trying to load an csv file through logstash.

Please find the config file below

input {
    file {
        path => "D:\summer.csv"
        start_position => "beginning"
        sincedb_path => "nul"
filter {
    csv {
        separator => ","
        columns => ["Name","Sex","Games","Year","City"]
output {
    elasticsearch {
        hosts => "localhost"
        index => "summer"
    stdout { }

i saved the above code in logstash_olym.conf under bin folder
When i run logstash using logstash -f logstash_olym.conf

i get below message (No errors), but it doesn't accept any keys and i dont have any option other that terminating it using Ctrl+C

D:\Prabhakaran\AINADEL\Softwares\logstash-6.4.0\logstash-6.4.0\bin>logstash -f logstash_olym.conf
Sending Logstash logs to D:/Prabhakaran/AINADEL/Softwares/logstash-6.4.0/logstash-6.4.0/logs which is now configured via log4j2.properties
[2018-08-31T16:34:06,182][WARN ][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified
[2018-08-31T16:34:07,395][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"6.4.0"}
[2018-08-31T16:34:14,610][INFO ][logstash.pipeline ] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>2, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50}
[2018-08-31T16:34:15,581][INFO ][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://localhost:9200/]}}
[2018-08-31T16:34:15,613][INFO ][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck_url=>http://localhost:9200/, :path=>"/"}
[2018-08-31T16:34:16,122][WARN ][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://localhost:9200/"}
[2018-08-31T16:34:16,248][INFO ][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>6}
[2018-08-31T16:34:16,260][WARN ][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the type event field won't be used to determine the document _type {:es_version=>6}
[2018-08-31T16:34:16,319][INFO ][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["//localhost"]}
[2018-08-31T16:34:16,354][INFO ][logstash.outputs.elasticsearch] Using mapping template from {:path=>nil}
[2018-08-31T16:34:16,458][INFO ][logstash.outputs.elasticsearch] Attempting to install template {:manage_template=>{"template"=>"logstash-", "version"=>60001, "settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"default"=>{"dynamic_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"match"=>"", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}}
[2018-08-31T16:34:17,575][INFO ][logstash.pipeline ] Pipeline started successfully {:pipeline_id=>"main", :thread=>"#<Thread:0x1a9a2368 run>"}
[2018-08-31T16:34:17,828][INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]}
[2018-08-31T16:34:17,854][INFO ][filewatch.observingtail ] START, creating Discoverer, Watch with file and sincedb collections
[2018-08-31T16:34:18,696][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}

After running this when i check in http://localhost:9200/_cat/indices?v

it gives me below result

health status index uuid pri rep docs.count docs.deleted store.size pri.store.size
green open kibana_sample_data_flights 8ALyDNdcTEmGWH4S8GlrPg 1 0 13059 0 6.6mb 6.6mb
green open .kibana 435xwaPbS4W0LPv4FVP1dw 1 0 22 0 48.1kb 48.1kb

which has only 2 index that doesn't have the index "summer" which i mentioned in the conf file. I am a newbie to ELK stack. Please guide me to process further.

Even i am unable to load csv file...
as observed from logsttach log file i received 2 error as below
1.Explicit value for 'scheme' was declared logstash
2.no implicit conversion from nil to integer logstash
am using logstash 6.4

Thanks @sandeepursks

As i checked the logs using --debug command. I found below errors.
1 -->
[2018-09-03T19:33:44,527][DEBUG][io.netty.util.internal.NativeLibraryLoader] Unable to load the library 'netty_tcnative_windows_x86_64', trying other loading mechanism.

java.lang.UnsatisfiedLinkError: no netty_tcnative_windows_x86_64 in java.library.path

2 -->
[2018-09-03T19:33:44,560][DEBUG][io.netty.util.internal.NativeLibraryLoader] netty_tcnative_windows_x86_64 cannot be loaded from java.libary.path, now trying export to -Dio.netty.native.workdir: C:\Users\prabhakaran.d\AppData\Local\Temp

java.lang.UnsatisfiedLinkError: no netty_tcnative_windows_x86_64 in java.library.path
Suppressed: java.lang.UnsatisfiedLinkError: no netty_tcnative_windows_x86_64 in java.library.path

Please guide me.

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