clc sql

Executes a SQL statement.

Usage:

clc sql [query] [flags]

Parameters:

Parameter Required Description Default

Parameter	Required	Description	Default
`--format, -f`	Optional	Output format. Supported formats: `csv` `delimited` `json` `table`	`delimited` in non-interactive mode, `table` in interactive mode.

--format, -f

Optional

Output format. Supported formats:

csv
delimited
json
table

delimited in non-interactive mode, table in interactive mode.

Global parameters

Parameter Description Default

--config, -c

Path to the configuration file in YAML format.

The following locations are tried in order for the existence of config.yaml

Current working directory
The parent directory of the clc executable
$CLC_HOME/default directory

--format, -f

Set the output format

csv
delimited: By tab characters
json
table

Interactive mode: table
Non-interactive mode: delimited

--log.level

Set the log level, one of:

debug
info
warning
error

info

--log.path

Set the log path. Use stderr to log to the screen (stderr).

$CLC_HOME/logs/YYYY-MM-DD.log where YYYY-MM-DD is today’s date.

--quiet, -q

Prevent displaying unnecessary output.

false

--verbose

Enable output with more information.

false

--timeout

Timeout for operation to complete.

The duration is a string in the form of AMOUNTunit where AMOUNT is an integer, and unit is one of the following:

ms: milliseconds
s: seconds
m: minutes
h: hours

Underscore (_) character is ignored in the AMOUNT. unit is optional and defaults to s if not specified.

The following are a few of the valid DURATIONs:

5: 5 seconds
5s: 5 seconds
10000ms: 10000 milliseconds
10_000_000ms: 10000000 milliseconds

This is a client-side timeout, the operation you started maybe in progress on the server-side even if the given timeout is exceeded.

Querying with SQL using the Hazelcast CLC

You can run SQL queries in both interactive and non-interactive mode of the Hazelcast CLC.

Non-Interactive mode
Interactive mode

$ clc sql -c prod "SELECT * from cities"
1	United Kingdom	London	9540576
4	United States	Los Angeles	3985520
5	Turkey	Ankara	5309690
7	Brazil	Sao Paulo	22429800

clc
> SELECT * FROM cities
---------------------------------------------------------------------------------
      __key | country                   | city                      | population
---------------------------------------------------------------------------------
          1 | United Kingdom            | London                    |    9540576
          4 | United States             | Los Angeles               |    3985520
          5 | Turkey                    | Ankara                    |    5309690
          7 | Brazil                    | Sao Paulo                 |   22429800
---------------------------------------------------------------------------------

clc sql

Querying with SQL using the Hazelcast CLC

Help and support