Constraints Table constraints PRIMARY KEY INDEX CHECK Column constraints NOT NULL Constraints Table constraints Table constraints are constraints that are applie...

Version 4.2.2 Fixes Version 4.2.2 Released on 2020-07-28. Note If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 4.2.2. We re...

Integrations File Service Discovery Remote Endpoints and Storage Alertmanager Webhook Receiver Management Other Integrations In addition to client libraries and exporters...

Version 4.5.2 Fixes Version 4.5.2 Released on 2021-06-15. Note If upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 4.5.2. We recommend...

Column Policy strict dynamic Column Policy The Column Policy defines if a table enforces its defined schema or if it’s allowed to store additional columns which are a not d...

Altering tables Updating parameters Changing the number of shards Decreasing the number of shards Increase the number of shards Adding columns Closing and opening tables Rena...

Version 4.3.0 Breaking Changes Deprecations Changes Performance improvements SQL Standard and PostgreSQL compatibility improvements Administration Error handling improvements ...

Scalar functions String functions concat('first_arg', second_arg, [ parameter , ... ]) format('format_string', parameter, [ parameter , ... ]) substr('string', from, [ count...

Scalar functions String functions concat('first_arg', second_arg, [ parameter , ... ]) format('format_string', parameter, [ parameter , ... ]) substr('string', from, [ count...

Optimistic Concurrency Control Introduction Optimistic update Optimistic delete Known limitations Optimistic Concurrency Control Introduction Even though CrateDB does not ...