New Features in Release 23.1

Added Support for SQL BETWEEN Operator

Implemented the SQL BETWEEN operator. This is a convenience operator that makes it easier to write queries that include range predicates with both a lower and an upper bound. For example, the query

select * from users where age between 20 and 30

is equivalent to the query

select * from users where 20 <= age and age <= 30

Java 11 is Required

This release now requires using Java 11 or later for both client applications and for running the store.

Removed Support for Hive

Removed support for Hive, including all of the classes in the oracle.kv.hadoop.hive.table package. Hive support was removed because this release requires Java 11 and the Hive package has not been updated to support that Java release. Hive support was needed for BigDataSQL, which is now also no longer supported.