How to load two different tables into two different indices of elasticsearch?

[duyihuacn]

I have two different tables, for example, user and event. And there are two indices in elasticsearch, index_user and index_event, how to do configuration in .sh files in folder elasticsearch-jdbc/bin? Could we just leverage only one .sh file?

[duyihuacn]

We could do it by two different .sh files, just change the configuration item "statefile" in the .sh file, e.g. in user.sh: "statefile" : "user_statefile.json" ;
and in event.sh: "statefile" : "event_statefile.json"

[sanaulla123]

I think you can leverage one .sh file by specifying the index in the SQL under the "_index" column