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