Version 4.4.0

    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.

    Table of Contents

    • The settings , 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.

    Changes

    • 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 .

    • Improved the performance of queries on the 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 type.

    • 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 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 which is available as an enterprise feature.

    • Added the sys.snapshot_restore table to track the progress of the operations.

    • Added the to_char scalar function for and interval argument data types.

    • Added the scalar function.

    • Added the rank window function, which is available as an enterprise feature.