Real-Time Unified Data Layers: A New Era for Scalable Analytics, Search, and AI

Download the White Paper
CrateDB Logo
  • Product
    • Database
      • Overview
      • SQL examples
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Use cases
    • Real-time analytics
    • Hybrid search
    • AI/ML integration
    • AI chatbots
    • Internet of Things
    • Geospatial analytics
    • Log & event analysis
  • Industries
    • Energy
    • Financial Services
    • FMCG
    • Logistics
    • Manufacturing
    • Oil, gas & mining
    • Smart city solutions
    • Technology platforms
    • Telco
    • Transportation
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • Login
  • Get Started
Toggle Doc Menu
Search
    • CrateDB Cloud
    • Self-Managed
    • Getting Started
    • Reference Manual
      • Running CrateDB
      • Configuration
      • General Use
      • Administration
      • SQL Syntax
      • Client Interfaces
      • CrateDB Editions
      • Appendices
    • Admin UI
    • Crash CLI
    • Drivers and Integrations
    • Support
    • Community
    • Integration Tutorials
    • Sample Applications
  Feedback

  Suggest improvement

  Edit page

  View page source

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 is a low-level reference manual.

Check out Getting Started With CrateDB for beginner documentation.

Check out the CrateDB Guide for high-level documentation, including overviews, best practices, and tutorials.

See also

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

Table of Contents

  • Running CrateDB
    • Introduction
    • Command Line Options
    • Signal Handling
  • Configuration
    • Node Specific Settings
    • Cluster Wide Settings
    • Session Settings
    • Logging
    • Environment Variables
  • General Use
    • Data Definition
    • Data Manipulation
    • Querying Crate
    • 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)
    • Ingestion Framework
    • Optimization
    • Jobs Management
    • JMX Monitoring
    • Snapshots
    • Cloud Discovery
    • Usage Data Collector
  • SQL Syntax
    • General SQL
    • SQL Statements
  • Client Interfaces
    • HTTP Endpoint
    • PostgreSQL Wire Protocol
  • CrateDB Editions
    • Enterprise Features
    • Community Edition
  • Appendices
    • Release Notes
    • Compatibility
    • SQL Standard Compliance

Subscribe to the CrateDB Newsletter now

CrateDB Logo
  • Imprint
  • Contact
  • Legal
Follow us
Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook