Version 1.0.0

    Note

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

    You cannot perform a rolling upgrade to this version. Any upgrade to this version will require a .

    Warning

    Before upgrading, you should back up your data.

    • Removed from information_schema.tables, information_schema.columns, and information_schema.table_constraints in favour of table_schema.

    • Possibly BREAKING blob storage changes:

    • Changed blob storage to utilize all paths listed under path.data.

      • Changed the directory layout in case a custom blobs.path is configured. This allows running two nodes on the same machine pointing to the same blobs.path without conflicts.

        These changes require a manual migration for users who have blob tables and either had:

      Please run the provided before updating to examine whether you are affected by these changes. The migration script will tell you what has to be done.

    • Removed Java 7 support

    • Improved error message if a function is unsupported with .

    • Nested numeric factors do not require brackets any more; e.g. SELECT + - 10 is now supported.

    • Added subscript support for cast and try_cast . e.g.: SELECT cast(coordinates AS array(double))[1] FROM sys.summits is now possible

    • Upgraded Elasticsearch to 2.4.2.

    • Added scalar functions latitude and longitude to extract latitude and longitude of a geo_point.

    • Improved performance of array_cat and array_difference scalar functions if the array contains function expressions.

    • New setting stats.service.interval which allows to control the refresh interval of the table statistics used to create optimal query execution plans.

    • Added support for global aggregations on subselects.

    • Added the -C option for providing CrateDB settings and deprecated usage of the prefix with -D option.

    • Added support for global aggregations on joins

    • Log unhandled HTTP related exceptions as debug instead of error.

    • Removed the duplicate rowcount field from the HTTP response.

    • Added the search_path session setting parameter. The default table schema can be set with SET SESSION search_path = schema_name.

    • Updated crate-admin to 1.0.1 which includes the following changes:

      • Fixed an issue that caused incorrect URL paths if the project gets built.

        Implemented new layout for the admin-ui.

      • Local development: do not store base_uri permanently in localStorage but keep it in URL.

      • Added Pepper contact widget which displays various Crate.io support Channels in a user friendly way.

      • The first node in the node list is selected by default.

      • The first table in the table list is selected by default.

      • Developer news from Crate.io website are now loaded correctly into newsfeed.

    • Updated Crash to 0.20.0 which includes the following change:

    • Updated information_schema metadata queries to reflect the current state of CrateDB.