Connecting to the SQL Service
To use the SQL service, the Jet engine must be enabled on the cluster. For information about how to enable the Jet engine, see Securing Jobs.
You can connect to the SQL service of a Hazelcast member using one of the following options:
|You cannot run SQL queries on lite members. This limitation will be removed in future releases.|
The easiest way to run SQL queries on a cluster is to connect to the SQL shell.
To connect to the SQL shell, run the
hz-cli sql command of your member’s built-in CLI.
$LOCAL_IP placeholder with your member’s local IP address.
docker run --network hazelcast-network -it --rm hazelcast/hazelcast:5.0.5 hz-cli --targets hello-world@$LOCAL_IP sql
--targets parameter tells the SQL shell to connect to the member at the given IP address in a cluster called