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.
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 .
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.