Getting data from mysql multiple tables

Elastic Stack Elasticsearch
1

I am indexing one table using jdbc plugin query and using timestamp column to check for any update and insert but now, I have to import multiple tables from db.
What would be the efficient way:-

  1. I used the sql join query in jdbc plugin? Is it going to be able to check for update in all the tables(i have timestamp column in every table).
    2: I should make multiple indices for all the tables and run a script for every table to index?
    What would be the best way and if any other suggestions?
2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.