Hi,
I've been at this for a while and cant seem to load a csv file to AWS opensearch from logstash. Any help will be appreciated.
"""
[ERROR] 2022-10-23 04:09:20.063 [Converge PipelineAction::Create] agent - Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of [A-Za-z0-9_-], [ \t\r\n], "#", "=>" at line 20, column 20 (byte 528) after output {\n\telasticsearch {\n \t\thosts => ["https://vpc-testdomain-recasfbwzdjs34opg4u1l6ul5skrke4.us..."]\n \t\tindex => "billing-log"\n \t\tdocument_type => "CSV"\n \t\tuser => "useradmin"\n ilm", :backtrace=>["/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:32:in `compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:210:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:72:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:48:in `initialize'", "org/jruby/RubyClass.java:911:in `new'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:50:in `execute'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:381:in `block in converge_state'"]}
[INFO ] 2022-10-23 04:09:20.157 [LogStash::Runner] runner - Logstash shut down.
"""
If I disable or set line to true then I get::
[ERROR] 2022-10-23 04:22:09.417 [Converge PipelineAction::Create] agent - Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of [A-Za-z0-9_-], [ \t\r\n], "#", "=>" at line 20, column 20 (byte 528) after output {\n\telasticsearch {\n \t\thosts => ["https://https://vpc-testdomain-recasfbwzdjs34opg4u1l6ul5skrke4.us..."]\n \t\tindex => "billing-log"\n \t\tdocument_type => "CSV"\n \t\tuser => "useradmin"\n ilm", :backtrace=>["/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:32:in `compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:210:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:72:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:48:in `initialize'", "org/jruby/RubyClass.java:911:in `new'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:50:in `execute'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:381:in `block in converge_state'"]}
[INFO ] 2022-10-23 04:22:09.549 [LogStash::Runner] runner - Logstash shut down.
csv as:
Month,Redshift,Relational Database Service,EC2-Instances,EC2-Other,Total
2/1/22,"$4,300 ","$7,000 ","$7,000 ","$7,000 ","$116,300 "
3/1/22,"$29,353 ","$12,325 ","$4,494 ","$3,299 ","$55,092 "
4/1/22,"$4,692 ","$2,025 ",$693 ,$257 ,"$8,240 "
5/1/22,"$4,865 ","$2,083 ",$727 ,$258 ,"$8,533 "
6/1/22,"$4,866 ","$2,025 ",$710 ,$262 ,"$8,472 "
7/1/22,"$5,033 ","$2,083 ",$747 ,$273 ,"$8,859 "
8/1/22,"$5,033 ","$2,083 ",$772 ,$272 ,"$9,478 "
9/1/22,"$4,864 ","$2,025 ",$846 ,"$1,976 ","$11,511 "