That’s very helpful, thanks for your reminder. I will look into whether ES rest client is backward compatible.
On 11/23/2021 07:34，Andrei Sereda<[email protected]> wrote： +1 Also take a look at vendor's official support schedule: https://www.elastic.co/support/eol I think it is safe to upgrade ES rest client to currently supported version. On Mon, Nov 22, 2021, 19:00 Julian Hyde <[email protected]> wrote: +1 Sounds like a good idea. On Nov 22, 2021, at 6:40 AM, Zhe Hu <[email protected]> wrote: Hi, community. Recently, when I tried to fix bugs in Elasticsearch Adapter, I’ve found that some new features in released Elasticsearch cannot be applied in Calcite, since the Elasticsearch version in Calcite is 7.0.1. For instance, as CALCITE-4868 mentioned, I want to sort aggregation results by multi_terms(supported after ES 7.1.11) as it’s more suitable under such circumstances than terms aggregation, however the DSL is not supported in Calcite currently. Moreover, I've browsed Elasticsearch's release notes roughly, and there are many new SQL features were added from 7.0.1 to 7.15.2, and lots of bugs were fixed meanwhile(if needed, I will spend some time to collect such info that benefits Calcite users). Since we use RestClient in Elasticsearch Adapter, there are still some cons about upgrading ES version, like new DSL couldn’t be used in old version Elasticsearch cluster, current use case might need to be adjusted. Nevertheless, I’m still wondering if we can upgrade the Elasticsearch version to 7.15, which could enrich ES Adapter's ablility as much as possible. Best regards, Zhe Hu
