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