A newer version of Hazelcast is available.

View latest

SQL Statements

Hazelcast supports the following SQL statements. Explore the available statements and find more details about them.

DML Statements

Statement Usage

SELECT

Read data from a table.

SINK INTO/INSERT INTO

Ingest data into a map and/or forward data to other systems.

UPDATE

Overwrite values in map entries.

DELETE

Delete map entries.

DDL Statements

Statement Usage

CREATE MAPPING

Map a local or remote data object to a table that Hazelcast can access.

SHOW MAPPINGS

Get the names of existing mappings.

DROP MAPPING

Remove a mapping.

Job Management

Statement Usage

CREATE JOB

Create a job that is not tied to the client session.

ALTER JOB

Restart, suspend, or resume a job.

SHOW JOBS

Get the names of all running jobs.

DROP JOB

Cancel a job.

CREATE OR REPLACE SNAPSHOT (Enterprise only)

Create a snapshot of a running job so you can stop and restart it at a later date.

DROP SNAPSHOT (Enterprise only)

Cancel a running job.