• 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