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