A newer version of Hazelcast Platform 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

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 a snapshot of a running job so you can stop and restart it at a later date.

DROP SNAPSHOT Enterprise

Drop an existing snapshot.