SQL Statements

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

DML Statements

Statement Usage

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.

Read data from a table.

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

Overwrite values in map entries.

Delete map entries.

Statement Usage

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.

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

Get the names of existing mappings.

Remove a mapping.

Statement Usage

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.

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

Restart, suspend, or resume a job.

Get the names of all running jobs.

Cancel a job.

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

Cancel a running job.