New Features

This section includes new features and enhancements.

If a new feature or enhancement relates to a Zendesk request, the associated Zendesk reference number is displayed, for example (10118).

New Features in NuoDB 6.0.2

Added Log-Structured Archive (LSA) to improve Storage Manager (SM) write performance

For more information, see Log-Structured Archive (LSA).

Added Merge Tree indexing to improve performance for random insert or update operations

For more information, see Merge Tree Indexing.

Merge Tree indexing is supported only for non-unique indexes.

nuoarchive check now displays LSA atom statistics

To display the quantities and a size histogram of each type of atom in LSA, use nuoarchive check --show-stats. For more information, see NuoDB Archive - Checking.

Added support for Java 21

Added Java 21 runtime support for the Administrative Process (AP) and the JDBC driver. For more information, see System Requirements.

Added additional logging information to nuoadmin.log during database upgrade

During a database upgrade, the messages logged to nuoadmin.log include the storage group ID on which the update has been applied.

Added the SYSTEM.MULTIINDEXES pseudo table to view information about Merge Tree indexes and their components

For more information, see MULTIINDEXES System Table Description.

Added the following fields to the LASTSTATEMENT system table

  • HASHHITS

  • HASHINSERTS

  • HASHPROBES

For more information, see LASTSTATEMENT System Table Description.

Added the following fields to the TABLES system table

  • AUTOCREATESTATS

  • NORECOMPUTE

For more information, see TABLES System Table Description.

Added the following fields to the CONNECTIONS system table

  • COORDINATORCONNID

  • COORDINATORNODEID

  • COORDINATORHANDLE

For more information, see CONNECTIONS System Table Description.

Added the following system tables

  • COLUMNGROUPS

  • COLUMNGROUPFIELDS

Added the VALUESBETWEEN and DATAAFFINITYMAPPING built-in table functions

For more information, see SQL Table Functions.

Added additional BEFORE/AFTER DDL event triggers for sequences, procedures, functions, views, users, and schemas

Added DEFAULT as an alias for the UNPARTITIONED storage group

For more information, see Predefined Storage Groups.

Added the BUILTINFUNCTIONS systems table

For more information, see BUILTINFUNCTIONS System Table Description.

Added a new capability to remove the identity property of a generated column (13738)

Added the nuoarchive check --show-disk-stats option

For more information, see NuoDB Archive - Checking.

Added the nuoarchive restore --restore-archive option to replace the nuoarchive restore --restore-dir option

For more information, see NuoDB Archive - Restoring.

Added the --archive-type argument to nuocmd subcommands

To specify the type of archive used to restore, use the nuocmd restore archive --archive-type <archive_type> argument, and to specify the type of archive used to start a containerized SM, use the nuocmd start sm --archive-type <archive_type> argument.

Added the FOR UPDATE WAIT <lock_timeout_in_sec> clause in SELECT statements

For more information, see SELECT.

New Features Previously Included in NuoDB 5.1.x Releases

Applied additional logging obfuscation for SQL statements (14132)

Upgrade to the current release to apply the latest NuoDB security patches.

Added support for Hibernate 6 generated SQL statements with JOIN group syntax (13781)

Hibernate 6 generated JOIN group syntax that wraps join predicates in parentheses was not supported in NuoDB. For example, Hibernate 6 generated SQL query such as, SELECT * FROM a JOIN (b JOIN c on x) on y, is now supported.

Added the Right Hash Outer Join execution operator for faster query execution

For more information, see Execution Plan Operators.

Added Spill to Disk support for hash join and hash grouping operators to reduce memory usage for large hash operations

Added lock-wait-timeout to the SYSTEM.CONNECTIONPROPERTIES pseudo table to view the lock wait timeout value for an existing connection

See the example on Connection Properties.

Improved the performance and execution times for SQL queries that include variables

SQL queries that include variables are now recompiled to generate a more optimized execution plan, resulting in better performance and faster execution times.

Added SQL syntax support for RIGHT OUTER join operations

For more information, see SELECT and RIGHT OUTER Join Operations.

Improved the performance and execution times for SQL queries that include variables in LIKE

SQL queries that include a variable in the LIKE operator are now considered for reoptimization by the v3 optimizer.

Improved the performance of SQL queries by extending the range of indexes for 'Bitmap intersections'

The optimizer will consider more 'Bitmap intersections' than before, providing additional opportunities to find an optimal access path. In particular, if a specific index is chosen to satisfy a property such as a join predicate or ordering, it will now check if that index can be further improved by intersecting it with additional indices.

Added the licenseFilePath property to configure the path to the NuoDB license file

For more information, see Setting nuoadmin.conf Properties.

Added the EXPLAIN (ANALYZE_GRAPH {ON|OFF}) option to debug performance characteristics of complex query plans

The EXPLAIN (ANALYZE_GRAPH {ON|OFF}) option displays the Graphviz representation of the explain plan. Use any Graphviz viewer to produce a graphical representation of the explain plan to aid in debugging and troubleshooting complex query plans.

For more information, see EXPLAIN.

Optimized the execution of SQL queries that includes timestamp literals

When executing a SQL query that includes a comparison operation of a string or a timestamp to a date literal, a performance optimization has been added by converting the operand opposite the date literal to a date.

Enabled the use of Optimizer Hints in SQL Data Manipulation Language (DML) statements

For more information, see Using Optimizer Hints.

Added support for Common Table Expression (CTE) using the WITH statement

For more information, see WITH.

Improved the performance of grouping and aggregation operations using the Hash grouping execution plan operator

For more information, see Execution Plan Operators.

Improved atom read prioritization on the syncing SM to reduce archive sync time

Reduce the number of atom loads required to complete archive synchronization