• Tutorials
• Installation
• First use
• Create user
• Create sharded table
• Generate time series data
• Normalize time series data intervals
• How-To Guides
• CrateDB and Linux
  • Run CrateDB on Debian GNU/Linux
  • Run CrateDB on Red Hat Linux
  • Run CrateDB on Ubuntu
• CrateDB and containers
  • Run CrateDB on Docker
  • Run CrateDB on Kubernetes
• CrateDB and cloud hosting
  • Run CrateDB on Amazon Web Services (AWS)
  • Run CrateDB on Microsoft Azure
• Rolling upgrade
• Full restart upgrade
• Bootstrap checks
• CrateDB multi-node setup
• CrateDB multi-zone setup
• Scaling CrateDB on Kubernetes
• Memory configuration
• Sharding guide
• Insert performance
  • Insert methods
  • Bulk inserts
  • Parallel inserts
  • Configuration tuning for inserts
  • Testing inserts performance
• Select performance
• Migrating from MySQL
• Migrating from MongoDB
• Troubleshooting with sys-tables
• Troubleshooting with the crate-node command
• CrateDB on Azure IoT
• Distributed Machine Learning At The Edge
• Data Ingestion using Kafka and Kafka Connect
• Data Stream Pipelines with CrateDB and StreamSets Data Collector
• Data Enrichment using IoT Hubs, Azure Functions and CrateDB
• CrateDB with R
• Reports with CrateDB and Power BI Desktop
• Real Time Reports with CrateDB and Power BI
• Distributed Deep-Learning with CrateDB and TensorFlow
• Troubleshooting CrateDB on Docker with jcmd
• Reference
• Concepts
  • Joins
  • Clustering
  • Storage and consistency
  • Resiliency
• CLI tools
• Configuration
  • Node-specific settings
  • Cluster-wide settings
  • Session settings
  • Logging
  • Environment variables
• General use
  • Data definition
  • Creating tables
  • Data types
  • System columns
  • Generated columns
  • Constraints
  • Storage
  • Partitioned tables
  • Sharding
  • Replication
  • Shard allocation filtering
  • Column policy
  • Fulltext indices
  • Fulltext analyzers
  • Show Create Table
  • Views
  • Altering tables
  • Data manipulation
  • Querying
  • Selecting data
  • Joins
  • Union All
  • Refresh
  • Fulltext search
  • Geo search
  • Built-in functions and operators
  • Scalar functions
  • Aggregation
  • Arithmetic operators
  • Table functions
  • Comparison operators
  • Array comparisons
  • Subquery expressions
  • Window functions
  • User-defined functions
  • Blobs
  • Optimistic Concurrency Control
  • Information schema
• Administration
  • System information
  • Runtime configuration
  • User management
  • Privileges
  • Authentication
  • Authentication Methods
  • Host-Based Authentication (HBA)
  • Secured communications (SSL/TLS)
  • Optimization
  • Jobs management
  • JMX monitoring
  • Snapshots
  • Cloud discovery
  • Usage Data Collector
• SQL syntax
  • General SQL
  • Constraints
  • Value expressions
  • Lexical structure
  • SQL Statements
  • ALTER CLUSTER
  • ALTER TABLE
  • ALTER USER
  • ANALYZE
  • BEGIN
  • START TRANSACTION
  • COMMIT
  • COPY FROM
  • COPY TO
  • CREATE ANALYZER
  • CREATE BLOB TABLE
  • CREATE FUNCTION
  • CREATE REPOSITORY
  • CREATE SNAPSHOT
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE USER
  • CREATE VIEW
  • DEALLOCATE
  • DELETE
  • DENY
  • DISCARD
  • DROP ANALYZER
  • DROP FUNCTION
  • DROP REPOSITORY
  • DROP SNAPSHOT
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • EXPLAIN
  • GRANT
  • INSERT
  • KILL
  • OPTIMIZE
  • REFRESH
  • RESTORE SNAPSHOT
  • REVOKE
  • SELECT
  • SET and RESET
  • SET LICENSE
  • SET AND RESET SESSION AUTHORIZATION
  • SET TRANSACTION
  • SHOW COLUMNS
  • SHOW CREATE TABLE
  • SHOW SCHEMAS
  • SHOW TABLES
  • SHOW (session settings)
  • UPDATE
  • VALUES
• Client interfaces
  • HTTP endpoint
  • PostgreSQL wire protocol
• Appendices
  • Release Notes
  • Unreleased Changes
  • Version 4.6.1
  • Version 4.6.0
  • Version 4.5.4
  • Version 4.5.3
  • Version 4.5.2
  • Version 4.5.1
  • Version 4.5.0
  • Version 4.4.3
  • Version 4.4.2
  • Version 4.4.1
  • Version 4.4.0
  • Version 4.3.4
  • Version 4.3.3
  • Version 4.3.2
  • Version 4.3.1
  • Version 4.3.0
  • Version 4.2.7
  • Version 4.2.6
  • Version 4.2.5
  • Version 4.2.4
  • Version 4.2.3
  • Version 4.2.2
  • Version 4.2.1
  • Version 4.2.0
  • Version 4.1.8
  • Version 4.1.7
  • Version 4.1.6
  • Version 4.1.5
  • Version 4.1.4
  • Version 4.1.3
  • Version 4.1.2
  • Version 4.1.1
  • Version 4.1.0
  • Version 4.0.12
  • Version 4.0.11
  • Version 4.0.10
  • Version 4.0.9
  • Version 4.0.8
  • Version 4.0.7
  • Version 4.0.6
  • Version 4.0.5
  • Version 4.0.4
  • Version 4.0.3
  • Version 4.0.2
  • Version 4.0.1
  • Version 4.0.0
  • Version 3.3.6
  • Version 3.3.5
  • Version 3.3.4
  • Version 3.3.3
  • Version 3.3.2
  • Version 3.3.1
  • Version 3.3.0
  • Version 3.2.8
  • Version 3.2.7
  • Version 3.2.6
  • Version 3.2.5
  • Version 3.2.4
  • Version 3.2.3
  • Version 3.2.2
  • Version 3.2.1
  • Version 3.2.0
  • Version 3.1.6
  • Version 3.1.5
  • Version 3.1.4
  • Version 3.1.3
  • Version 3.1.2
  • Version 3.1.1
  • Version 3.1.0
  • Version 3.0.7
  • Version 3.0.6
  • Version 3.0.5
  • Version 3.0.4
  • Version 3.0.3
  • Version 3.0.2
  • Version 3.0.1
  • Version 3.0.0
  • Version 2.3.11
  • Version 2.3.10
  • Version 2.3.9
  • Version 2.3.8
  • Version 2.3.7
  • Version 2.3.6
  • Version 2.3.5
  • Version 2.3.4
  • Version 2.3.3
  • Version 2.3.2
  • Version 2.3.1
  • Version 2.3.0
  • Version 2.2.7
  • Version 2.2.6
  • Version 2.2.5
  • Version 2.2.4
  • Version 2.2.3
  • Version 2.2.2
  • Version 2.2.1
  • Version 2.2.0
  • Version 2.1.10
  • Version 2.1.9
  • Version 2.1.8
  • Version 2.1.7
  • Version 2.1.6
  • Version 2.1.5
  • Version 2.1.4
  • Version 2.1.3
  • Version 2.1.2
  • Version 2.1.1
  • Version 2.1.0
  • Version 2.0.7
  • Version 2.0.6
  • Version 2.0.5
  • Version 2.0.4
  • Version 2.0.3
  • Version 2.0.2
  • Version 2.0.1
  • Version 2.0.0
  • Version 1.2.0
  • Version 1.1.6
  • Version 1.1.5
  • Version 1.1.4
  • Version 1.1.3
  • Version 1.1.2
  • Version 1.1.1
  • Version 1.1.0
  • Version 1.0.6
  • Version 1.0.5
  • Version 1.0.4
  • Version 1.0.3
  • Version 1.0.2
  • Version 1.0.1
  • Version 1.0.0
  • SQL compatibility
  • SQL standard compliance
  • Resiliency Issues
  • Glossary

false

.wrapper-content-right

.version-select-container,#contents,.rubric,.headerlink