Connecting to the SQL Service
Before you Begin
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.
Connection Options
You can connect to the SQL service of a Hazelcast member using one of the following options:
-
SQL shell or Management Center: For fast prototyping.
-
JDBC driver or the Java client: For Java applications.
| You cannot run SQL queries on lite members. This limitation will be removed in future releases. |
Using the SQL Shell
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.
Mac and Linux
bin/hz-cli sqlWindows
bin/hz-cli.bat sqlReplace the $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 sqlThe --targets parameter tells the SQL shell to connect to the member at the given IP address in a cluster called hello-world.
