Previous Next JavaScript must be enabled to correctly display this content

## New Features in Release 18.1

Support for Group-by and Aggregate Function

This release introduces support for the group-by clause and the following aggregate functions: count(*), count(expr), sum(expr), avg(expr), min(expr) and max (expr).

Joining Tables in the Same Table Hierarchy

Support for joining tables that belong to the same table hierarchy — parent-child table joins — is now available.

Zone Affinity

Users can specify master affinity for the primary zones that are in close proximity to the client application. This feature allows the system to favor placing master nodes in primary zones that have master affinity set so that write operations are directed to nearby zones for more predictable latency.