crate.io Logo
  • Products
    • CrateDB Overview
    • CrateDB Cloud
    • CrateDB Edge
    • CrateDB On-Premises
    • Pricing
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
    • Industries
  • Docs
  • Resources
    • Blog
    • Events
    • Newsletter
    • Videos
    • Webinars
    • White Papers
  • Community
  • Login
  • Get CrateDB
Toggle Doc Menu
Search
    • Install CrateDB
    • CrateDB
    • Reference
      • Concepts
      • CLI tools
      • Configuration
      • General use
      • Administration
      • SQL syntax
      • Client interfaces
      • Appendices
    • 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:master
master latest 5.2 5.1 4.8 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
    • 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

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub

Product

  • CrateDB Overview
  • CrateDB Cloud
  • CrateDB Edge
  • CrateDB On-Premises
  • Compare
  • Pricing
  • Download
  • CrateDB Cloud Login

Customers

  • Success Stories
  • Use Cases
  • Industries

Resources

  • Blog
  • Events
  • Content Library
  • Newsletter
  • Videos
  • Webinars
  • White Papers

Developers

  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute

Company

  • About us
  • Jobs
  • Partners
  • Newsroom
  • Security
  • Contact

Follow us

Follow us on Twitter Follow us on Twitter Follow us on LinkedIn Follow us on LinkedIn Follow us on Facebook Follow us on Facebook Follow us on YouTube Follow us on YouTube Follow us on GitHub Follow us on GitHub
  • Legal
  • Privacy Policy
  • Imprint

erdf
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo

Subscribe to the Crate.io Newsletter now