ES Version Support

SoftClient4ES supports Elasticsearch versions 6 through 9 with version-specific client libraries.

Client Library Matrix

Elasticsearch	Client Library	Scala	JDK
ES 6.x	`softclient4es6-rest-client`	2.12, 2.13	8+
ES 7.x	`softclient4es7-rest-client`	2.12, 2.13	8+
ES 8.x	`softclient4es8-java-client`	2.12, 2.13	8+
ES 9.x	`softclient4es9-java-client`	2.13 only	17+

JDBC Driver Matrix

Elasticsearch	Artifact	JDK
ES 6.x	`softclient4es6-jdbc-driver`	8+
ES 7.x	`softclient4es7-jdbc-driver`	8+
ES 8.x	`softclient4es8-jdbc-driver`	8+
ES 9.x	`softclient4es9-jdbc-driver`	17+

JDBC driver JARs are Scala-version-independent and include all dependencies.

Arrow Flight SQL Server Matrix

Elasticsearch	Docker Image
ES 6.x	`softnetwork/softclient4es6-arrow-flight-sql:latest`
ES 7.x	`softnetwork/softclient4es7-arrow-flight-sql:latest`
ES 8.x	`softnetwork/softclient4es8-arrow-flight-sql:latest`
ES 9.x	`softnetwork/softclient4es9-arrow-flight-sql:latest`

REPL Client Matrix

Elasticsearch	Artifact	JDK
ES 6.x	`softclient4es6-cli`	8+
ES 7.x	`softclient4es7-cli`	8+
ES 8.x	`softclient4es8-cli`	8+
ES 9.x	`softclient4es9-cli`	17+

Feature Compatibility

DDL Features

Feature	ES6	ES7	ES8	ES9
CREATE/ALTER/DROP TABLE	Yes	Yes	Yes	Yes
Legacy templates	Yes	Yes	No	No
Composable templates	No	Yes	Yes	Yes
Partitioning (date_index_name)	Yes	Yes	Yes	Yes
Generated scripts (SCRIPT AS)	Yes	Yes	Yes	Yes
STRUCT	Yes	Yes	Yes	Yes
ARRAY<STRUCT>	Yes	Yes	Yes	Yes
Pipelines	Yes	Yes	Yes	Yes
Watchers	Yes	Yes	Yes	Yes
Enrich Policies	No	Yes*	Yes	Yes
Materialized Views	No	Yes*	Yes	Yes

* Requires ES 7.5+

DML Features

Feature	ES6	ES7	ES8	ES9
INSERT	Yes	Yes	Yes	Yes
INSERT AS SELECT	Yes	Yes	Yes	Yes
UPDATE	Yes	Yes	Yes	Yes
DELETE	Yes	Yes	Yes	Yes
COPY INTO	Yes	Yes	Yes	Yes
JSON / JSON_ARRAY	Yes	Yes	Yes	Yes
PARQUET / DELTA_LAKE	Yes	Yes	Yes	Yes

DQL Features

Feature	ES6	ES7	ES8	ES9
SELECT with WHERE/ORDER BY/LIMIT	Yes	Yes	Yes	Yes
Nested fields	Yes	Yes	Yes	Yes
UNION ALL	Yes	Yes	Yes	Yes
Set operators (`UNION` / `INTERSECT` / `EXCEPT`)	Yes	Yes	Yes	Yes
Derived tables	Yes	Yes	Yes	Yes
`WHERE` subqueries	Yes	Yes	Yes	Yes
Correlated subqueries	Yes	Yes	Yes	Yes
CTEs (non-recursive)	Yes	Yes	Yes	Yes
Cross-index JOINs	Yes	Yes	Yes	Yes
JOIN UNNEST	Yes	Yes	Yes	Yes
Aggregations (GROUP BY/HAVING)	Yes	Yes	Yes	Yes
Window functions	Yes	Yes	Yes	Yes
Parent-level nested array aggs	Yes	Yes	Yes	Yes
All function families	Yes	Yes	Yes	Yes
`STDDEV` / `VARIANCE` over a transform	No	Yes	Yes	Yes
SHOW/DESCRIBE commands	Yes	Yes	Yes	Yes

A ✔ here means the Elasticsearch major does not stand in the way — every row was executed against that version. It is not a statement about the venue: derived tables, CTEs, correlated subqueries and the set operators other than UNION ALL need the relational engine wherever they run, on every one of these versions alike. See Known Limitations & Roadmap.

Materialized Views

Feature	ES6	ES7	ES8	ES9
Materialized Views	No	Yes*	Yes	Yes
WITH SCHEDULE NOW	No	No	Yes	Yes

* Requires ES 7.5+

Resolvers

To use SoftClient4ES artifacts, add the JFrog repository:

sbt

resolvers += "Softnetwork Releases" at "https://softnetwork.jfrog.io/artifactory/releases/"
resolvers += "Softnetwork Snapshots" at "https://softnetwork.jfrog.io/artifactory/snapshots/"

Maven

<repository>
  <id>softnetwork-releases</id>
  <url>https://softnetwork.jfrog.io/artifactory/releases/</url>
</repository>

Gradle

repositories {
    maven { url "https://softnetwork.jfrog.io/artifactory/releases/" }
}