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
        • Data Definition
        • Data Manipulation
        • Querying Crate
        • Built-in Functions and Operators
        • User-Defined Functions
        • Blobs
        • Optimistic Concurrency Control
        • Information Schema
      • 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

General UseΒΆ

This section of the documentation covers any feature primarily of interest to a general user.

Table of Contents

  • 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 Crate
    • 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

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