I am trying to use Elastic Search SQL JDBC driver to connect to ES cluster. Our indices are partition by date dynamically, for example, we have testdata_2021-0914, testdata_2021-0915, etc. It appears each of these index is mapped as an individual database table.
It's quite common to partition ES index by date for scalability reason and ease of purging old data. My question is how can I query across all the indices? Thanks.