New Features in Release 21.1

MRCounter Type

Added support for the new MR_COUNTER SQL type, which can be used with INTEGER, LONG and NUMBER value types in multi-region tables. The new type supports merging independent modifications made in multiple regions into a single combined value.

Left Outer Join

Added support for the LEFT OUTER JOIN syntax to be compatible with standard ANSI SQL.

Indexes for Nested Arrays and Maps

This release adds support for indexing arrays and maps that are nested within other arrays or maps.

New SQL Functions

Added new SQL functions to access information about row storage size, index storage size, modification time, containing partition, and containing shard. Also added a function to convert a string to JSON.