SQL Reference Overview

This section describes data types, functions, operators, and SQL statements supported by KWDB for time-series and relational data processing, including the following documents:

• Data Types
  • Time-Series Data Types
  • Relational Data Types
• Functions
  • Time-Series Functions
  • Relational Functions
• Operators
  • Time-Series Operators
  • Relational Operators
• Identifiers
• Keywords
• DDL Statements
  • Time-Series Data
    • Databases
    • Tables
    • Columns
    • Tags
    • Indexes
    • Ranges
    • Partitions
    • Zones
    • Comments
  • Relational Data
    • Databases
    • Schemas
    • Tables
    • Columns
    • Views
    • Materialized Views
    • Indexes
    • Constraints
    • Sequences
    • Ranges
    • Partitions
    • Zones
    • Comments
    • Stored Procedures
    • Triggers
• DML Statements
  • Time-Series Data
    • SELECT
    • INSERT
    • DELETE
    • UPDATE
    • PREPARE
    • SELECT Optimization
  • Relational Data
    • SELECT
    • INSERT
    • UPDATE
    • UPSERT
    • DELETE
    • TRUNCATE
    • SELECT Optimization
  • Cross-Model Query
• Database Management Statements
  • User Management
  • Role Management
  • Privilege Management
  • Audit Management
• Other Statements
  • User-Defined Functions
  • User-Defined Variables
  • Queries
  • Transactions
  • Statistics
  • Jobs
  • Schedules
  • Sessions
  • Cluster Settings
  • Declarations
  • Cursors
  • Delimiter
  • Stream
• System Views
  • kwdb_internal
  • pg_catalog
• NULL Value Handling
• View SQL Statements