Hi
I am currently using logstash-plugin-jdbc to pull data from mysql to elasticsearch.I want to know how can I input multi table from mysql into same index? here is some of the code
input {
jdbc {
# the control statement
statement => select * from table1,table2
}
I want to know how can I input multi table from mysql into same index?
What does that mean? Do you want to join data from multiple tables or do you want to index rows for different tables separately and independently from each other?
statement => select * from table1,table2
First of all you need to quote the query, and secondly I'm pretty sure you don't want a cross join query like above.
What does that mean? Do you want to join data from multiple tables or do you want to index rows for different tables separately and independently from each other?
I mean I want to join data from two table into one index.
which mean I want let table1 and table2 insert into the index "test".
I changed to use
# the control statement
statement_filepath => "/root/sql/product.sql
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.