Elastic Search SQL JDBC driver maps each index to a table

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.

From SELECT | Elasticsearch Guide [7.14] | Elastic

The name can be a pattern pointing to multiple indices (likely requiring quoting as mentioned above) with the restriction that all resolved concrete tables have exact mapping .

So check out that link to pattern :slight_smile: