Version 4.4.0

Released on 2021-01-19.

Note

If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 4.4.0.

We recommend that you upgrade to the latest 4.3 release before moving to 4.4.0.

A rolling upgrade from 4.3.x to 4.4.0 is supported.

Before upgrading, you should back up your data.

Deprecations

The settings discovery.zen.publish_timeout, discovery.zen.commit_timeout, discovery.zen.no_master_block, discovery.zen.publish_diff.enable have been marked as deprecated and will be removed in a future version.

Improved the performance of queries on the sys.health table.
Added support for using the optimized primary key lookup plan if additional filters are combined via AND operators.
Improved the performance of queries on the sys.allocations table in cases where there are filters restricting the result set or if only a sub-set of the columns is selected.
Improved the performance for queries which select a subset of the columns available in a wide table.

Added arithmetic operation support for the numeric type.
Added support for the numeric data type and allow the sum aggregation on the numeric type. Note that the storage of the numeric data type is not supported.
Extended the RowDescription message that can be sent while communicating with PostgreSQL clients to include a table_oid and a attr_num based on the values that are also exposed via the pg_catalog.pg_attribute table. This improves compatibility with clients which make use of these attributes.
Changed the format_type function to use the PostgreSQL compatible type name notation with [] suffixes for arrays, instead of _array.
Added the delimiter option for COPY FROM CSV files. The option is used to specify the character that separates columns within a row.
Added the empty_string_as_null option for COPY FROM CSV files. If the option is enabled, all column’s values represented by an empty string, including a quoted empty string, are set to NULL.

Added information about the shards located on the node to the NodeInfo MXBean which is available as an enterprise feature.
Added the sys.snapshot_restore table to track the progress of the snapshot restore operations.

Added the to_char scalar function for timestamp and interval argument data types.
Added the split_part scalar function.
Added the dense_rank window function, which is available as an enterprise feature.
Added the rank window function, which is available as an enterprise feature.