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