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.