Version 5.8.0 - Unreleased¶

Note

In development. 5.8.0 isn’t released yet. These are the release notes for the upcoming release.

Note

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

We recommend that you upgrade to the latest 5.7 release before moving to 5.8.0.

A rolling upgrade from 5.7.x to 5.8.0 is supported. Before upgrading, you should back up your data.

Warning

Tables that were created before CrateDB 4.x will not function with 5.x and must be recreated before moving to 5.x.x.

You can recreate tables using COPY TO and COPY FROM or by inserting the data into a new table.

Table of contents

Breaking Changes ¶

Removed the index.warmer.enabled setting and its corresponding column within the settings column of information_schema.tables and information_schema.table_partitions. The setting had been deprecated in CrateDB 4.2.0.
Removed network column from sys.nodes table. The column was deprecated since version_2.3.0_ and all of the sub-columns where returning 0.

None

dshunter107 added support for the IF NOT EXISTS clause to CREATE TABLE AS statement.

None

None

Extended the lookup-join optimization to make it applicable to more complex queries when they include sub-queries, an inner-equi-join and if there is a large imbalance in size between the joined tables. This optimization can be disabled with the session setting:
```
SET optimizer_equi_join_to_lookup_join = false
```
Note that this setting is experimental, and may change in the future.
Improved the partition filtering logic to narrow partitions if the partition is based on a generated column with a type not matching the return type of the generated expression.

Extended Connections JMX MBean, to expose more detailed network statistics information. On top of the previously exposed open and total connections, number of messages and bytes sent and received per protocol are also available.
Added transport['total'] column to sys.nodes connections column, which exposes the number of total connections via the Transport protocol.