Version 2.2.0 Changelog Breaking Changes Changes Version 2.2.0 Released on 2017/09/19. Note If you are upgrading a cluster, you must be running CrateDB Version 1.1.3 or h...

Version 2.2.0 Changelog Breaking Changes Changes Version 2.2.0 Released on 2017/09/19. Note If you are upgrading a cluster, you must be running CrateDB Version 1.1.3 or h...

ALTER CLUSTER Synopsis Description Arguments REROUTE RETRY FAILED DECOMMISSION <nodeId | nodeName> SWAP TABLE Options GC DANGLING ARTIFACTS ALTER CLUSTER Alte...

Version 2.0.2 Changelog Fixes Version 2.0.2 Released on 2017/06/23. Warning CrateDB 2.x versions prior 2.0.4 (including this version) contain a critical bug which leads to d...

Version 2.2.0 Changelog Breaking Changes Changes Version 2.2.0 Released on 2017/09/19. Note If you are upgrading a cluster, you must be running CrateDB Version 1.1.3 or hi...

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

Joins Cross joins Inner joins Outer joins Left outer joins Right outer joins Full outer joins Join conditions Available join algorithms Nested loop join algorithm Block has...

Altering Tables Updating Parameters Changing the Number of Shards Decrease the Number of Shards Increase the Number of Shards Adding Columns Closing and Opening Tables Renami...

Data types Classification Primitive types Geographic types Container types boolean Character types character varying(n) , varchar(n) text Numeric types Floating-Point...

Constraints Table constraints PRIMARY KEY INDEX CHECK Column constraints NOT NULL Constraints Table of contents Table constraints PRIMARY KEY INDEX C...