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`	Add data to a map and/or forward data to other systems.
`UPDATE`	Overwrite data in a table.
`DELETE`	Delete data from a table.

Read data from a table.

Add data to a map and/or forward data to other systems.

Overwrite data in a table.

Delete data from a table.

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.
`CREATE VIEW`	Create a virtual table based on the result set of a SQL query. Views can be reused in other queries.
`DROP VIEW`	Delete a view.
`CREATE DATA CONNECTION`	Create the metadata required to connect to an external system for later use.
`DROP DATA CONNECTION`	Delete a data connection.
`SHOW RESOURCES`	Get the names of accessible resources for a data connection.
`CREATE INDEX`	Create a sorted, hash, or bitmap index for a given map.

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

Get the names of existing mappings.

Remove a mapping.

Create a virtual table based on the result set of a SQL query. Views can be reused in other queries.

Delete a view.

Create the metadata required to connect to an external system for later use.

Delete a data connection.

Get the names of accessible resources for a data connection.

Create a sorted, hash, or bitmap index for a given map.

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 Edition	Create a snapshot of a running job so you can stop and restart it at a later date.
`DROP SNAPSHOT` Enterprise Edition	Drop an existing snapshot.

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.

DROP SNAPSHOT Enterprise Edition

Drop an existing snapshot.