crate.io Logo
  • Products
    • CrateDB
    • CrateDB Cloud
    • CrateDB Edge
    • Pricing
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
  • Compare
  • Company
    • About us
    • Careers
    • Partners
    • Newsroom
    • Newsletter
    • Events
    • Contact us
  • Resources
    • Documentation
    • Videos
    • Webinars
    • White Papers
    • Community
  • Blog
  •  
  • Login
  • Contact us
Toggle Doc Menu
Search Documentation
    • CrateDB
      • Tutorials
      • How-To Guides
      • Reference
        • Concepts
          • Joins
            • Types of join
            • Joins in CrateDB
          • Clustering
            • Components of a CrateDB Node
            • Multi-node setup: Clusters
            • Cluster behavior
            • Application use case
          • Storage and consistency
            • Data storage
            • Atomicity at document level
            • Durability
            • Addressing documents
            • Consistency
            • Cluster meta data
          • Resiliency
            • Overview
        • CLI tools
          • crate
            • Synopsis
            • Options
            • Signal handling
            • Example
          • crate-node
            • Synopsis
            • Commands
            • Options
        • Configuration
          • Node-specific settings
            • Basics
            • Node types
            • Read-only node
            • Hosts
            • Ports
            • Paths
            • Plug-ins
            • CPU
            • Memory
            • Garbage collection
            • Authentication
            • Secured communications (SSL/TLS)
            • Cross-origin resource sharing (CORS)
            • Blobs
            • Repositories
            • Queries
            • JavaScript language
            • Custom attributes
          • Cluster-wide settings
            • Non-runtime cluster-wide settings
            • Collecting stats
            • Shard limits
            • Usage data collector
            • Graceful stop
            • Bulk operations
            • Discovery
            • Routing allocation
            • Recovery
            • Memory management
            • Query circuit breaker
            • Field data circuit breaker
            • Request circuit breaker
            • Accounting circuit breaker
            • Stats circuit breakers
            • Total circuit breaker
            • Thread pools
            • Metadata
          • Session settings
            • Usage
            • Supported session settings
          • Logging
            • Application logging
            • JVM logging
          • Environment variables
            • Application variables
            • JVM 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
            • Inserting data
            • Updating data
            • Deleting data
            • Import and export
          • 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
            • CREATE OR REPLACE
            • Supported types
            • Overloading
            • Determinism
            • DROP FUNCTION
            • Supported languages
          • Blobs
            • Creating a table for blobs
            • Custom location for storing blob data
            • List
            • Altering a blob table
            • Deleting a blob table
            • Using blob tables
          • Optimistic Concurrency Control
            • Introduction
            • Optimistic update
            • Optimistic delete
            • Known limitations
          • Information schema
            • Access
            • Virtual tables
        • Administration
          • System information
            • Cluster
            • Nodes
            • Node checks
            • Shards
            • Segments
            • Jobs, operations, and logs
            • Cluster checks
            • Health
            • Repositories
            • Snapshots
            • Snapshot Restore
            • Summits
            • Users
            • Allocations
            • Shard table permissions
            • Sys jobs tables permissions
            • pg_stats
          • Runtime configuration
          • User management
            • CREATE USER
            • ALTER USER
            • DROP USER
            • List users
          • Privileges
            • Introduction
            • Privilege types
            • Hierarchical inheritance of privileges
            • Behavior of GRANT, DENY and REVOKE
            • List privileges
          • Authentication
            • Authentication Methods
            • Host Based Authentication (HBA)
          • Secured communications (SSL/TLS)
            • SSL/TLS configuration
            • Setting up a Keystore/Truststore with a certificate chain
          • Optimization
            • Introduction
            • Multiple table optimization
            • Partition optimization
            • Segments upgrade
          • Jobs management
          • JMX monitoring
            • Setup
            • Using Docker
            • JMX Beans
            • Exposing JMX via HTTP
          • Snapshots
            • Snapshot
            • Restore
            • Cleanup
            • Requirements for using HDFS repositories
          • Cloud discovery
            • Amazon EC2 discovery
            • Microsoft Azure discovery
          • Usage Data Collector
            • Technical information
            • Admin UI tracking
            • Configuration
            • How to disable UDC
        • SQL syntax
          • General SQL
            • Constraints
            • Value expressions
            • Lexical structure
          • SQL Statements
            • ALTER CLUSTER
            • ALTER TABLE
            • ALTER USER
            • ANALYZE
            • BEGIN
            • 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 CONSTRAINT
            • 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
            • Introduction
            • Parameter substitution
            • Default schema
            • Column types
            • Bulk operations
            • Error handling
          • PostgreSQL wire protocol
            • Server compatibility and implementation status
            • Client compatibility
            • Implementation differences
        • Appendices
          • Release Notes
            • Versions
            • Older Versions
          • SQL compatibility
            • Implementation notes
            • Unsupported features and functions
          • SQL standard compliance
          • Resiliency Issues
            • Known issues
            • Fixed issues
          • Glossary
            • Terms
      • Clients and Tools
      • Admin UI
      • Crash CLI
    • CrateDB Cloud
      • Tutorials
      • How-To Guides
      • Reference
      • Croud CLI
    • JDBC
    • PHP DBAL
    • PHP PDO
    • Python
    • .NET Npgsql
    • Sample Applications
    • Support
v:4.5
master latest 4.5 3.3

CrateDB Reference¶

CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.

Note

This resource assumes you know the basics. If not, check out the Tutorials section for beginner material.

See also

CrateDB is an open source project and is hosted on GitHub.

Table of contents

  • Concepts
    • Joins
    • Clustering
    • Storage and consistency
    • Resiliency
  • CLI tools
    • crate
    • crate-node
  • Configuration
    • Node-specific settings
    • Cluster-wide settings
    • Session settings
    • Logging
    • Environment variables
  • General use
    • Data definition
    • Data manipulation
    • Querying
    • Built-in functions and operators
    • User-defined functions
    • Blobs
    • Optimistic Concurrency Control
    • Information schema
  • Administration
    • System information
    • Runtime configuration
    • User management
    • Privileges
    • Authentication
    • Secured communications (SSL/TLS)
    • Optimization
    • Jobs management
    • JMX monitoring
    • Snapshots
    • Cloud discovery
    • Usage Data Collector
  • SQL syntax
    • General SQL
    • SQL Statements
  • Client interfaces
    • HTTP endpoint
    • PostgreSQL wire protocol
  • Appendices
    • Release Notes
    • SQL compatibility
    • SQL standard compliance
    • Resiliency Issues
    • Glossary

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub
  • Product
  • CrateDB
  • CrateDB Cloud
  • Compare
  • Download
  • CrateDB Cloud Login
  • Pricing
  • Use Cases
  • Success Stories
  • Use Cases
  • IoT & Sensors
  • Time Series
  • Geospatial Tracking
  • Cybersecurity
  • Resources
  • Blog
  • Content Library
  • Videos
  • Webinars
  • White Papers
  • Developers
  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute
  • Company
  • About us
  • Jobs
  • Events
  • Newsletter
  • Partners
  • Press
  • Security
  • Contact
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo