1. Install CrateDB
2. CrateDB
2.1 Getting started
2.2 [Administration]
2.3 [Clustering]
2.4 Performance
2.4.1 [Memory configuration]
2.4.2 Sharding guide
2.4.3 [Insert performance]
2.4.4 [Select performance]
3. Reference
3.1 Concepts
3.2 CLI tools
3.3 Configuration
3.4 General use
3.4.1 Data definition
3.4.1.1 Creating tables
3.4.1.2 Data types
3.4.1.3 System columns
3.4.1.4 Constraints
3.4.1.5 Storage
Beside of storing the row data as-is (and indexing each value by default), each value term is stored into a Column Store by default. The usage of a Column Store is greatly improving global aggregations and groupings and enables ordering possibility as the data for one column is packed at one place. Using the Column Store limits the values of TEXT columns to a maximal length of 32766 bytes.
Turning off the Column Store in conjunction of turning off indexing will remove the length limitation.
CREATE TABLE t1 (
id INTEGER,
url TEXT INDEX OFF STORAGE WITH (columnstore = false)
);
3.4.1.6 Partitioned tables
3.4.1.7 Sharding
3.4.1.8 Replication
3.4.1.9 Shard allocation filtering
3.4.1.10 Column policy
3.4.1.11 Fulltext indecis
3.4.1.13 Fulltext analyzers
3.4.1.14 Show Create Table — CrateDB: Reference
3.4.1.15 Views — CrateDB: Reference
3.4.1.16 Altering tables — CrateDB: Reference
3.4.2
3.4.3
3.4.5 User-defined functions — CrateDB: Reference
3.5 Administration
3.5.1 System information
3.5.1.1 Cluster
3.5.2 Runtime configuraiton
3.5.3 User management — CrateDB: Reference
3.5.4 Privileges — CrateDB: Reference
3.5.8 Optimization — CrateDB: Reference
3.6 SQL syntax
3.6.1 General SQL
3.6.2 SQL Statements
CREATE TABLE
3.7 [Client interfaces]
3.7.1 Release Notes
3.7.2 SQL compatibility
3.7.3 SQL standard compliance
3.7.4 Resiliency Issues
3.7.5 [Glossary](Glossary — CrateDB: Reference
)
