SQL
Complete SQL reference for Apache Ignite 3, including fundamentals, syntax, and performance tuning.
In This Section
SQL Engine Architecture
Understanding the SQL engine, query processing pipeline, and distributed query execution.
Execute Queries
Run SQL from applications using prepared statements, parameter binding, and result processing.
Work with System Views
Query cluster metadata, metrics, and system information through SQL views.
DDL Commands
Data definition language including CREATE, ALTER, and DROP statements for schema management.
DML Commands
Data manipulation language including SELECT, INSERT, UPDATE, and DELETE operations.
Data Types
Supported SQL data types including numeric, string, temporal, and binary types.
Operators and Functions
Built-in SQL functions and operators for arithmetic, string manipulation, date operations, and aggregations.
Grammar Reference
Complete SQL syntax with railroad diagrams showing valid statement structures.
Keywords
Reserved SQL keywords and naming restrictions for identifiers.
SQL Conformance
SQL standards compliance and supported ANSI SQL features.
Distribution Zones
Control data distribution across cluster nodes for performance optimization.
EXPLAIN Statement
Analyze query execution plans to understand performance characteristics.
Performance Tuning
Best practices for SQL query optimization and performance improvement.
Next Steps
- Develop - Build applications with SQL
- Configure and Operate - Production deployment
- API Reference - SQL driver documentation