CrateDB Reference

CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of 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
  • Users and roles management
  • Privileges
  • Authentication
  • Secured communications (SSL/TLS)
  • Optimization
  • Jobs management
  • JMX monitoring
  • Snapshots
  • Foreign Data Wrappers
  • Logical replication
  • 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