This is a prerelease version.

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.