Hello i'm new to elasticsearch. I'm trying to join data that i imported from two sql tables and i do not really understand how to do that.
These are my config files to import data:
input {
jdbc {
jdbc_driver_library => "C:\Users\dkuiate\Downloads\ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => ""
jdbc_user => "gemini"
jdbc_password => "gemini"
jdbc_validate_connection => true
statement =>"select ......
where p.pid = t.priority and s.service_id = t.type_id
and e.env_id = t.od_env_id and b.ctr_id = t.bin_id and lc.lgl_ctr_id = b.lgl_ctr_id
and trunc(t.d_otime,'MONTH') >= to_date('1/6/2018','DD/MM/YYYY')"
}
}
output {
elasticsearch{
hosts => "localhost:9200"
index => "home"
document_type => "home_ticket"
# document_id => "%{id}"
}
}
and the second one is similar. I have around 10 000 rows of data so i can't do it manually, i used to do it manually but now it is just impossible. Can anybody help?
i want to be capable to make visualization joinning data from both two data set!
Do i have a way to do that while importing with the jdbc driver.
Thank you in advance