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

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.
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.

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 EditionThis feature requires Hazelcast Enterprise, a licensed edition of the Hazelcast Platform.	Create a snapshot of a running job so you can stop and restart it at a later date.
DROP SNAPSHOT Enterprise EditionThis feature requires Hazelcast Enterprise, a licensed edition of the Hazelcast Platform.	Drop an existing snapshot.