# ニューヨークのタクシーデータが取り込めない **URL:** \ **Category:** Logstash\ **Created:** [May 26, 2019, 6:14pm UTC](https://discuss.elastic.co/t/topic/182809 "2019-05-26T18:14:32Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ode.raita](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ode.raita/32/51209_2.png) [@ode.raita](https://discuss.elastic.co/u/ode.raita)\ **Post date:** [May 26, 2019, 6:14pm UTC](https://discuss.elastic.co/t/topic/182809/1 "2019-05-26T18:14:33Z")
> **[ニューヨーク市のタクシー乗降データでMachine Learningを体験する](https://www.elastic.co/jp/blog/experiencing-machine-learning-with-nyc-taxi-dataset)** > > Machine Learningを体験いただくには、みなさん自身のデータを使用されることが一番ですが、公開されているデータセットを用いても十分に実感できます。ニューヨーク市のタクシーの乗降データを用いて異常検知を行って見ましょう。 上記の設定を試していますが、以下のエラーが出ます。 なお、Elasticsearch/logstach/kibanaは6.8 X-packのライセンスはアクティブです [root@vmi247815 data]# /usr/share/logstash/bin/logstash -f nyc-taxi-yellow-translate-logstash3.conf WARNING: Could not find logstash.yml which is typically located in $LS\_HOME/config or /etc/logstash. You can specify the path using --path.settings. Continuing using the defaults Could not find log4j2 configuration at path /usr/share/logstash/config/log4j2.properties. Using default config which logs errors to the console [WARN] 2019-05-26 19:55:55.326 [LogStash::Runner] multilocal - Ignoring the 'pipelines.yml' file because modules or command line options are specified [INFO] 2019-05-26 19:55:55.345 [LogStash::Runner] runner - Starting Logstash {"logstash.version"=\>"6.8.0"} [INFO] 2019-05-26 19:56:06.835 [Converge PipelineAction::Create] pipeline - Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>6, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50} [INFO] 2019-05-26 19:56:07.518 [[main]-pipeline-manager] elasticsearch - Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}} [WARN] 2019-05-26 19:56:07.800 [[main]-pipeline-manager] elasticsearch - Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"} [INFO] 2019-05-26 19:56:08.090 [[main]-pipeline-manager] elasticsearch - ES Output version determined {:es\_version=\>6} [WARN] 2019-05-26 19:56:08.094 [[main]-pipeline-manager] elasticsearch - Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6} [INFO] 2019-05-26 19:56:08.148 [[main]-pipeline-manager] elasticsearch - New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]} [INFO] 2019-05-26 19:56:08.164 [Ruby-0-Thread-5: :1] elasticsearch - Using default mapping template [INFO] 2019-05-26 19:56:08.211 [Ruby-0-Thread-5: :1] 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"}}}}}}}} [ERROR] 2019-05-26 19:56:08.415 [[main]-pipeline-manager] pipeline - Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#LogStash::FilterDelegator:0x55a93fc", :error=\>"Translate: Missing or stray quote in line 1 when loading dictionary file at /root/data/taxi.csv", :thread=\>"#\"} [ERROR] 2019-05-26 19:56:08.436 [[main]-pipeline-manager] pipeline - Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\, :backtrace=\>["uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1899:in `block in shift'", "org/jruby/RubyArray.java:1792:in`each'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1867:in `block in shift'", "org/jruby/RubyKernel.java:1425:in`loop'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1821:in `shift'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/csv_file.rb:20:in`block in read\_file\_into\_dictionary'", "org/jruby/RubyIO.java:3511:in `foreach'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/csv_file.rb:18:in`read\_file\_into\_dictionary'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/file.rb:101:in `merge_dictionary'", "org/jruby/RubyMethod.java:132:in`call'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/file.rb:66:in `load_dictionary'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/file.rb:53:in`initialize'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/dictionary/file.rb:19:in `create'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-translate-3.2.3/lib/logstash/filters/translate.rb:166:in`register'", "org/logstash/config/ir/compiler/AbstractFilterDelegatorExt.java:56:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:259:in`register\_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:270:in `block in register_plugins'", "org/jruby/RubyArray.java:1792:in`each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:270:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:612:in`maybe\_setup\_out\_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:280:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:217:in`run'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:176:in `block in start'"], :thread=\>"#\"} [ERROR] 2019-05-26 19:56:08.448 [Converge PipelineAction::Create] agent - Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil} [INFO] 2019-05-26 19:56:08.864 [Api Webserver] agent - Successfully started Logstash API endpoint {:port=\>9600} [INFO] 2019-05-26 19:56:13.588 [LogStash::Runner] runner - Logstash shut down. ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [May 26, 2019, 8:01pm UTC](https://discuss.elastic.co/t/topic/182809/2 "2019-05-26T20:01:17Z")
> [@ode.raita](#): > > Translate: Missing or stray quote in line 1 when loading dictionary file at /root/data/taxi.csv What is in /root/data/taxi.csv? ---
**Author:** ![ode.raita](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ode.raita/32/51209_2.png) [@ode.raita](https://discuss.elastic.co/u/ode.raita)\ **Post date:** [May 27, 2019, 11:41am UTC](https://discuss.elastic.co/t/topic/182809/3 "2019-05-27T11:41:27Z")
Hi Badger, TAXI,csv = taxi+\_zone\_lookup This CSV is a list of area codes and area names ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 24, 2019, 11:41am UTC](https://discuss.elastic.co/t/topic/182809/4 "2019-06-24T11:41:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.