Jump to Content
Apache Ignite SQL DocumentationJavaC#/.NETC++SQL*IntegrationsIgnite for SparkTools
Guides
JavaC#/.NETC++SQL*IntegrationsIgnite for SparkToolsLog InExamplesAsk a QuestionApache Ignite SQL Documentation
Guides
Log InExamplesAsk a Question
SQL Reference Overview

Introduction

  • Overview
  • Getting Started

SQL Reference

  • SQL Reference Overview
  • SQL Conformance
  • Data Definition Language (DDL)
    • DROP INDEX
    • CREATE INDEX
    • CREATE USER
    • ALTER TABLE
    • CREATE TABLE
    • DROP TABLE
    • DROP USER
    • ALTER USER
  • Data Manipulation Language (DML)
    • INSERT
    • DELETE
    • SELECT
    • UPDATE
    • MERGE
  • Operational Commands
    • KILL QUERY
    • COPY
    • SET STREAMING
  • Aggregate Functions
    • BIT_AND
    • MIN
    • SUM
    • AVG
    • COUNT
    • GROUP_CONCAT
    • MAX
    • BIT_OR
  • System Functions
    • NULLIF
    • IFNULL
    • GREATEST
    • CASEWHEN
    • TABLE
    • DECODE
    • CAST
    • NVL2
    • CONVERT
    • LEAST
    • COALESCE
  • Transactions
  • Data Types
  • Date and Time Functions
    • DAYNAME
    • HOUR
    • DAY_OF_MONTH
    • MINUTE
    • EXTRACT
    • DAY_OF_WEEK
    • MONTHNAME
    • PARSEDATETIME
    • WEEK
    • MONTH
    • CURRENT_DATE
    • CURRENT_TIME
    • YEAR
    • DAY_OF_YEAR
    • QUARTER
    • DATEDIFF
    • CURRENT_TIMESTAMP
    • FORMATDATETIME
    • SECOND
    • DATEADD
  • String Functions
    • POSITION
    • STRINGDECODE
    • CONCAT_WS
    • OCTET_LENGTH
    • LOWER
    • SUBSTRING
    • LPAD
    • INSTR
    • REPEAT
    • REGEXP_LIKE
    • XMLSTARTDOC
    • REPLACE
    • RPAD
    • SOUNDEX
    • SPACE
    • INSERT
    • UTF8TOSTRING
    • LTRIM
    • STRINGTOUTF8
    • LEFT
    • HEXTORAW
    • XMLTEXT
    • CONCAT
    • BIT_LENGTH
    • DIFFERENCE
    • REGEXP_REPLACE
    • TRANSLATE
    • XMLCOMMENT
    • RIGHT
    • XMLCDATA
    • XMLATTR
    • RAWTOHEX
    • RTRIM
    • TRIM
    • TO_CHAR
    • UPPER
    • XMLNODE
    • LENGTH
    • ASCII
    • STRINGENCODE
    • LOCATE
    • CHAR
  • Numeric Functions
    • COMPRESS
    • BITGET
    • COT
    • BITOR
    • RAND
    • LOG10
    • BITAND
    • ROUND
    • RANDOM_UUID
    • ACOS
    • POWER
    • EXPAND
    • ATAN
    • EXP
    • MOD
    • BITXOR
    • SIN
    • RADIANS
    • TANH
    • SIGN
    • SINH
    • COSH
    • SQRT
    • LOG
    • CEILING
    • ENCRYPT
    • TRUNCATE
    • ROUNDMAGIC
    • ABS
    • FLOOR
    • ZERO
    • DEGREES
    • DECRYPT
    • PI
    • TAN
    • ASIN
    • SECURE_RAND
    • ATAN2
    • COS

Architecture

  • Geospatial Support
  • Local Queries
  • Schemas
  • Distributed Joins
  • Performance and Debugging
  • SQL Transactions
  • How Ignite SQL Works

SQL and Key-Value

  • SQL and Key-Value Usage

JDBC

  • JDBC Client Driver
  • JDBC Driver
  • Error Codes

ODBC

  • Querying and Modifying Data
  • Specification
  • Data Types
  • ODBC Driver
  • Connection String and DSN
  • Error Codes

Management and Monitoring

  • JDBC/ODBC Session Management

Tools and Analytics

  • SQLLine
  • Pentaho
  • SQL Tooling
  • Tableau
  • Apache Zeppelin

PHP Developer Guide

  • PHP PDO

Java Developer Guide

  • Schema and Indexes
  • Query Cancellation
  • SQL API
  • Custom SQL Functions

.NET Developer Guide

  • LINQ
  • SQL API
  • Schema and Indexes

LEGAL

  • Apache License
  • Copyright

C++ Developer Guide

  • Schema and Indexes
  • SQL API
Powered by 

SQL Reference Overview

Apache Ignite SQL Capabilities

❗️

This is a legacy Apache Ignite documentation

The new documentation is hosted here: https://ignite.apache.org/docs/latest/

The section contains an overview of SQL syntax supported by Apache Ignite:

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Aggregate Functions
  • Numeric Functions
  • String Functions
  • Date and Time Functions
  • System Functions
  • Data Types

Updated over 4 years ago