i have a conf as follows input { jdbc { statement => 'select type from item' type => "item" } } output { elasticsearch { document_type => '%{type}' } } the output type value is from statement field. what i want is the value defined by type => "item". any sugguestions?

Having type => "item" in the input declaration will set the value of field type to item, regardless of what is in your statement. This is because Logstash "decorates" the event with whatever tags you define, as well as type, after the input plugin has completed its data collection. As data leaves …

Discuss the Elastic Stack

Logstash jdbc type conflicts with statement field

Elastic Stack Logstash

copywrite (Dili) March 14, 2017, 10:20am 3

Thanks
problem solved.

Topic		Replies	Views
If [type] is not working in logstash 2.3.2 Logstash	6	3420	July 6, 2017
Logstash logstash-jdbc-input queries (mapping and type) Logstash	5	3014	July 6, 2017
Logstash-jdbc-input mapping issues [bug ] Logstash	3	1149	July 26, 2015
Query Logstash error type Logstash elastic-stack-monitoring	3	537	February 26, 2020
Logstash always output input event type as log Logstash	4	1523	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Logstash jdbc type conflicts with statement field

Related topics