---
title: Commands Supported by the Ocient JDBC CLI Program
slug: 0Iwz8pc2imETPa_YEtQ7N
description: Explore the commands supported by Ocient JDBC CLI program for streamlined data interaction.
docTags: 
createdAt: Thu Jul 21 2022 23:48:23 GMT+0000 (Coordinated Universal Time)
updatedAt: Fri Apr 10 2026 20:29:45 GMT+0000 (Coordinated Universal Time)
---

Commands are not case-sensitive in the Ocient® JDBC CLI program.&#x20;

For DDL statements, see [Data Definition Language (DDL) Statement Reference](<./././SQL Reference/Data Definition Language _DDL_ Statement Reference.md>).

:::hint{type="info"}
All commands, except QUIT, must end with a semicolon at the command line.
:::

:::hint{type="info"}
You can cancel any query that does not update data by pressing CTRL+C.
:::

### CANCEL

Cancels the current query that is still running on the system.

**Syntax**

```shell
CANCEL uuid;
```

| **Parameter** | **Data Type** | **Description**                                                                                                                                                                                                                                                        |
| ------------- | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| uuid          | String        | A query Universally Unique IDentifier (UUID) that is currently running. Use [LIST ALL QUERIES](./#list-all-queries), or search the `sys.queries` table to find the UUID. You must enclose the UUID in single quotes, such as `'c87b506f-66d6-4987-8bf7-1fd4a06b64b1'`. |

### CONNECT

Connects to a SQL Node. For details on the connection steps, see [Connect Using JDBC](<./././Connect to Ocient/Connect Using JDBC.md>).

**Syntax**

```shell
CONNECT TO <url> [ USER username USING password ] 
```

:::hint{type="info"}
The `<url>` parameter must follow this format:

`jdbc:ocient://node_address1:port1[,node_address2:port2[,...]]/database_name[;property=value[;...]]`
:::

:::hint{type="info"}
If you do not specify the `username` and `password`, then the database uses the default credentials specified at startup.
:::

**JDBC URL parameters**

| **Parameter**   | **Description**                                                                                                                                                                      |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `node_address`  | A hostname or IP address.<br />The database attempts to connect using each `DNSName:Port` pair in the comma-delimited list from left to right until a successful connection happens. |
| `port`          | Standard JDBC port number is `4050`. <br />For details about ports, see [Ports](<./././Ocient Simulator.md>).                                                                        |
| `database_name` | The identifier used for your database.                                                                                                                                               |

**Additional JDBC URL Parameters**

The JDBC URL can include these optional parameters in the key-value format `property=value`. Separate each parameter pair by semicolons. &#x20;

URL parameters are case-insensitive.&#x20;

:::hint{type="info"}
To authenticate using Single Sign-On, set the `handshake` parameter to `SSO` and leave the `user` and `password` parameters empty. For example: `jdbc:ocient://DNSName:Port[,IP2:Port2,...]/databaseName;handshake=SSO;user=;password=;`
:::



| **Parameter**                    | **Description**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| -------------------------------- |   |
| `bulkLoadChunkSize`              | The number of rows to include in each JSON data file (chunk) uploaded. The default value is `60000`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| `bulkLoadCleanupOnFailure`       | If you set this parameter value to `true`, the driver deletes the temporary files and pipelines even if the load fails. The default value is `true`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| `bulkLoadFailOnError`            | If you set this parameter value to `true`, `executeBatch()` fails if any `INSERT` operation fails.<br /> <br />If you set this parameter value to `false`, `executeBatch()` falls back to a standard multi-row `INSERT` operation if any INSERT operation fails. The default value is `false`.                                                                                                                                                                                                                                                                                                                                                                                             |
| `bulkLoadPollIntervalSeconds`    | The number of seconds to wait between polling the `sys.pipelines` system catalog table for load status. The default value is `2`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| `bulkLoadSshKeyPath`             | The absolute path to the password-less private SSH key file. The default value is `~/.ssh/id_rsa`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| `bulkLoadSshHostKeyVerification` | Controls how the JDBC driver verifies an SSH server host key for bulk load connections. <br /><br />Supported values are: <br /><br />`acceptAll` (default) — The driver accepts all host keys. The connector does not check the server host key against the `known_hosts` file and does not output warning logs.&#xA;`strict` — The driver accepts only hosts with keys present in the `known_hosts` file (see the `bulkLoadSshKnownHostsPath` parameter). The driver rejects unknown hosts or hosts with changed keys.&#xA;`acceptNew` — The driver accepts new hosts and adds their keys to the `known_hosts` file, but rejects hosts with keys changed from the data in `known_hosts`. |
| `bulkLoadSshKnownHostsPath`      | The path to the `known_hosts` file, which contains SSH verification keys. The system uses this path only if the `bulkLoadSshHostKeyVerification` parameter is set to `strict` or `acceptNew`. <br /><br />The default path is `~/.ssh/known_hosts`.                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| `bulkLoadSshUser`                | The SSH username to use when connecting to Loader Nodes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| `bulkLoadThreshold`              | The minimum number of rows in a batch group to trigger a bulk load. The default value is `25000`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| `defaultSchema`                  | Default schema.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| `enableBulkLoad`                 | Enables the high-speed bulk load feature. Set this parameter value to `true` to enable this feature. Otherwise, set this parameter to `false` to leave the feature disabled. The default value is `false`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| `force`                          | If set to true (case-sensitive), this parameter disables load-balancing for the connection.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| `handshake`                      | Specifies the handshake protocol used for the connection. <br />Supported options include: `"CBC", "GCM", "SSO"` <br />`"GCM"` — (Galois/Counter Mode). This is the default encryption and is the recommended password encryption algorithm. <br />`"CBC"` — (Cipher Block Chaining) for password encryption. <br />`"SSO"` — Single Sign-On.                                                                                                                                                                                                                                                                                                                                              |
| `identityprovider`               | An SSO integration established in the database. For details, see [CREATE SSO INTEGRATION](docId\:OS6IxWVQ3VQYxXebcnfdE).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| `logfile`                        | The filename to use for JDBC tracing.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `loglevel`                       | If set to ERROR (warnings and errors only) or DEBUG (verbose tracing) and logfile is also set, JDBC tracing is enabled. This parameter is case-sensitive.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| `longQueryThreshold`             | Estimated query runtime in milliseconds before deeper query optimization runs. <br />`0` — Use database server default. <br />`-1` — Never run deeper optimization.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| `maxRows`                        | Maximum allowed result set size in the number of rows.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `maxRowsPerInsertBatch`          | The maximum number of rows to combine into a single multi-row `INSERT` SQL statement when executing a batch load. If the total number of rows in a batch group exceeds this limit, the driver splits the group into multiple sub-statements. <br /><br />The default value is 128,000 rows.                                                                                                                                                                                                                                                                                                                                                                                                |
| `maxTempDisk`                    | Maximum allowed temp disk usage as a percentage (0 - 100).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| `maxThreadsPerResultSet`         | The maximum number of threads the client uses to fetch rows from the server per Result Set, as defined in the [official JDBC documentation](https://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html). In this context, a thread represents a logical connection to the database. <br />Applications that create and operate on Statement objects concurrently might find value in setting this property. Defaults to `0`, which effectively creates an unbounded Result Set thread pool.                                                                                                                                                                                         |
| `maxTime`                        | Maximum allowed runtime of a query in seconds before it is canceled on the server.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| `networkTimeout`                 | Network connection timeout in milliseconds. <br />If unspecified, this defaults to 10000 milliseconds.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `parallelism`                    | Limits a query to running on a specified number of cores on each CPU.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `password`                       | The password for the user.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| `priority`                       | Query priority. This sets the priority for queries to run on the server side. <br />If unspecified, this defaults to `1.0`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| `priorityAdjustFactor`           | The default query priority adjustment value. For details, see [SET ADJUSTFACTOR](./#set-adjustfactor).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `priorityAdjustTime`             | The default frequency to adjust the query priority. For details, see [SET ADJUSTTIME](./#set-adjusttime).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| `serviceClassName`               | Specifies the name of the service class to use for the database session.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| `sparkMode`                      | When you set this parameter to `true`, the driver enables Apache® Spark™-specific JDBC behavior intended to improve compatibility with the Ocient Spark connector. For details, see [JDBC Spark Connector](docId\:nTt8auTzysZNgWeDjAgsW).<br /><br />This parameter defaults to `false` if you are connecting directly using the Ocient JDBC driver (e.g., connecting with the `DriverManager` class or CLI). &#xA;&#xA;Otherwise, if you are using the Spark connector (catalog or `.format("ocient")`), the default is `true`.                                                                                                                                                           |
| `ssoNumericAddress`              | Specifies the SSO callback URL as `127.0.0.1`. When this value is `false`, the URL is `localhost`. The default value is `false`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| `ssoOAuthCodeCallbackPort`       | If `ssoOAuthFlow=authorizationCode`, this property specifies the port that the SSO authorization uses. <br />If unspecified, the default value is `7050`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| `ssoOAuthFlow`                   | This property is only applicable if SSO authorization is enabled. <br />Forces the driver to use either the "authorizationCode" or "deviceGrant" flow to establish a Single Sign-On session. <br />If this property is not provided, the Ocient® System uses the "authorizationCode" flow when a web browser is available to the client and the "deviceGrant" flow when a web browser is not available to the client.                                                                                                                                                                                                                                                                      |
| `ssoDebugMode`                   | When set to `true`, the system records additional log messages related to SSO.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| `ssoOktaNativeTokenPath`         | The path to the OKTA® Native Token (AES-256GCM JWE). The path is relative to your home directory (i.e. '\~/').                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| `ssoSslCallback`                 | Specifies whether to use HTTPS instead of HTTP for the SSO callback URL. The default value is `false`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `ssoTimeoutSeconds`              | The number of seconds before the SSO connection request times out. The default value is `60`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| `statementPooling`               | ℹ️ This property has been removed as of Ocient JDBC version 2.104 and later.  <br />When set to `ON`, recently used statements are cached. <br />Set to `OFF` when using a third-party application that implements statement pooling                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| `tls`                            | Can be set to `unverified` or `on`. Enables SSL/TLS encryption for the connection.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| `timeoutMillis`                  | Number of milliseconds before cancellable operations are timed out and killed by the driver. 0 means no timeout. Default: 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| `user`                           | The identifier of the user.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |

### DESCRIBE TABLE

Lists the columns of the specified table and its associated data types.&#x20;

**Syntax**

```shell
DESCRIBE TABLE [schema.]table [verbose]
```

| **Parameter** | **Description**                                                                                                                                    |
| ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| `table`       | A table identifier.                                                                                                                                |
| `schema`      | A qualifying schema name for the specified table. <br />If a qualifying schema is not specified for the table, the default name schema is assumed. |
| `verbose`     | If specified, the Ocient® System prints the full column metadata for the specified table as returned by GetColumns.                                |

### DESCRIBE VIEW

Returns the query text used to create the specified view.

**Syntax**

```shell
DESCRIBE VIEW [schema.]view [verbose]
```

| **Parameter** | **Description**                                                                                                                                    |
| ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| `view`        | A view identifier.                                                                                                                                 |
| `schema`      | A qualifying schema name for the specified table. <br />If a qualifying schema is not specified for the table, the default name schema is assumed. |
| `verbose`     | If specified, the Ocient System prints the full column metadata for the specified table as returned by GetColumns.                                 |

### EXTRACT

Extracts a result set in delimited files to a specified location. For details about using this command, see [Data Extract Tool](<./Data Extract Tool.md>).&#x20;

**Syntax**

```sql
EXTRACT TO location 
   { LOCAL | S3 } 
   [ OPTIONS ( [ param=value [ ,... ] ] ) ] AS query 
```

### GET JDBC VERSION

Returns the JDBC version of the driver.

**Syntax**

```shell
GET JDBC VERSION
```

### GET SCHEMA

Retrieves the default name schema for tables.

**Syntax**

```shell
GET SCHEMA
```

### KILL

Issues a hard kill command to the virtual machine to terminate a query running on the system. Use only if `CANCEL` fails.

**Syntax**

```shell
KILL uuid
```

| **Parameter** | **Description**                                                                                                                          |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| `uuid`        | A query UUID that is currently running. Use [LIST ALL QUERIES](./#list-all-queries), or search the `sys.queries` table to find the UUID. |

### LIST ALL QUERIES

List all the currently executing queries on the database. This is the equivalent of executing `SELECT * FROM sys.queries`.&#x20;

**Syntax**

```shell
LIST ALL QUERIES
```

### LIST INDEXES

Lists the indexes on the specified table and its columns.&#x20;

**Syntax**

```shell
LIST INDEXES [schema.]table [verbose]
```

| **Parameter** | **Description**                                                                                                                                    |
| ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| `table`       | A table identifier.                                                                                                                                |
| `schema`      | A qualifying schema name for the specified table. <br />If a qualifying schema is not specified for the table, the default name schema is assumed. |
| `verbose`     | If specified, the Ocient System prints the full column metadata for the specified table as returned by getIndexInfo.                               |

### LIST SYSTEM TABLES

Lists all system catalog tables in the database.&#x20;

**Syntax**

```shell
LIST SYSTEM TABLES [verbose]
```

| **Parameter** | **Description**                                                                         |
| ------------- | --------------------------------------------------------------------------------------- |
| `verbose`     | If verbose is specified, the full table metadata, as returned by getTables, is printed. |

### LIST TABLES

Lists all tables (in all schemata) in the database.&#x20;

**Syntax**

```shell
LIST TABLES [verbose]
```

| **Parameter** | **Description**                                                                         |
| ------------- | --------------------------------------------------------------------------------------- |
| `verbose`     | If verbose is specified, the full table metadata, as returned by getTables, is printed. |

### LIST VIEWS

Lists all views (in all schemata) in the database.&#x20;

**Syntax**

```shell
LIST VIEWS [verbose]
```

| **Parameter** | **Description**                                                                        |
| ------------- | -------------------------------------------------------------------------------------- |
| `verbose`     | If verbose is specified, the full table metadata, as returned by getViews, is printed. |

### OUTPUT GIS KML

Outputs the next query in KML format to the specified filename. This flag affects only the next query.&#x20;

This syntax prints out all GIS types to the KML file, and non-GIS types are added to the description of elements in the same row. You can upload this KML file to certain visualization tools.

**Syntax**

```shell
OUTPUT GIS KML <filename>
```

| **Parameter** | **Description**                 |
| ------------- | ------------------------------- |
| `filename`    | A filename for the KML output.  |

### OUTPUT NEXT QUERY&#x20;

Output the next query in CSV format to the specified filename. This flag only affects the next query. All subsequent queries print out their results.&#x20;

Add `APPEND` to add output to the specified file instead of overwriting it.

**Syntax**

```shell
OUTPUT NEXT QUERY filename [APPEND]
```

| **Parameter** | **Description**                 |
| ------------- | ------------------------------- |
| `filename`    | A filename for the CSV output.  |

### PERFORMANCE

Enables different levels of query result output for measuring benchmarks by using different performance options.&#x20;

**Syntax**

```shell
PERFORMANCE [ NETWORK | DATABASE | OFF ]
```

| **Parameter** | **Description**                                                                                                                                                                                                                                |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `OFF`<br />   | This is the default mode. <br />The system executes a query through all normal stages, including the database, client network, and client processing.                                                                                          |
| `NETWORK`     | The system executes a query through the database and client network, but discards rows before they are processed by the client (nothing is printed to stdout). <br />Use this mode when you think the client network is hindering performance. |
| `DATABASE`    | The system executes a query through the database only. The database does not send any matching rows to the client. <br />Use this mode when you think the database query execution is affecting performance.                                   |

:::hint{type="info"}
`PERFORMANCE ON` mode has been removed as of JDBC version 3.0.&#x20;
:::

### QUIT

Closes the command-line interface.

**Syntax**

```shell
QUIT
```

### REPORT LOG ON

Enables Apache® Log4J 2™ -based metrics collection and redirects reporting events to the configured appenders.&#x20;

:::hint{type="info"}
The `REPORT LOG ON` command requires JDBC driver version 2.88 or later. &#x20;
:::

The Log4j configuration determines the destination for report logs. The Ocient logger name is `com.ocient.util.ReportLogger`. For details about configuring Log4j, see [the Log4j documentation](https://logging.apache.org/log4j/2.x/manual/configuration.html).&#x20;

The default Log4j configuration routes report logs to the `RollingFileAppender`.  The default configuration includes these settings:

**Properties**

- `fileName="logs/${sys:ocient.jdbc.sessionId:-unknown}/report.log"`
- `filePattern="logs/${sys:ocient.jdbc.sessionId:-unknown}/%d{yyyy-MM-dd}-%i-report.log.gz`

**Rollover Policies**

- `TimeBasedTriggeringPolicy`
- `SizeBasedTriggeringPolicy (100MB)`

You can retrieve the default configuration from the `ocient-jdbc4` jar file by using an archive utility like **unzip**. For example:

```shell
unzip -p <path-to-ocient-jdbc4> log4j2.xml
```

**Syntax**

```shell
REPORT LOG ON [ interval ]
```

| **Parameter** | **Description**                                                                                 |
| ------------- | ----------------------------------------------------------------------------------------------- |
| `interval`    | Optional. Sets the Log4j reporting interval in seconds. <br />If unspecified, defaults to `30`. |

### REPORT LOG OFF

Disables file-based metrics collection.

:::hint{type="info"}
The `REPORT LOG OFF` command requires JDBC driver version 2.88 or later. &#x20;
:::

**Syntax**

```shell
REPORT LOG OFF
```

### SELECT

Retrieves the appropriate result set of a SQL `SELECT` statement.&#x20;

**Syntax**

```shell
SQL select statement
```

### SET MAXROWS

Sets the maximum number of rows allowed in a result set. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET MAXROWS num_of_rows
```

| **Parameter** | **Description**                                                                                                                                                                                                                                                                          |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `num_of_rows` | The maximum number of rows allowed in a result set. If a query returns more rows than the specified value, the result set is truncated by `num_of_rows`.<br />To disable this setting, you can either set the maximum rows to 0 or use the `RESET` keyword (e.g., `SET MAXROWS RESET;`). |

### SET ADJUSTFACTOR

Adjusts the query priority by a specified percentage amount at every interval set by the [SET ADJUSTTIME](./#set-adjusttime) command.&#x20;

:::hint{type="info"}
The `SET ADJUSTFACTOR` command requires JDBC driver version 2.52 or later. &#x20;
:::

&#x20;**Syntax**

```shell
SET ADJUSTFACTOR priorityAdjustFactor
```

| **Parameter**          | **Description**                                                                                                                                                                                                                                         |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `priorityAdjustFactor` | A percentage amount to raise or lower the query priority. Accepted values are in the range of \[-1,1].<br />At every interval set by the `priorityAdjTime`, the query priority is multiplied by `1 + priorityAdjustFactor` to get a new priority value. |

### SET ADJUSTTIME

Modifies how frequently the query priority is adjusted during the course of execution.&#x20;

:::hint{type="info"}
The `SET ADJUSTTIME` command requires JDBC driver version 2.52 or later. &#x20;
:::

&#x20;**Syntax**

```shell
SET ADJUSTTIME priorityAdjTime
```

| **Parameter**     | **Description**                                             |
| ----------------- | ----------------------------------------------------------- |
| `priorityAdjTime` | The frequency for adjusting the query priority in seconds.  |

### SET MAXTEMPDISK

Sets the maximum percentage of temporary disk used by queries. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET MAXTEMPDISK percentage
```

| **Parameter** | **Description**                                                                                                                                                                                     |
| ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `percentage`  | The maximum percentage of temporary disk used by queries. Any queries exceeding this threshold are killed. <br />To disable this setting, use the `RESET` keyword (e.g., `SET MAXTEMPDISK RESET;`). |

### SET MAXTIME

Sets the maximum query time. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET MAXTIME seconds
```

| **Parameter** | **Description**                                                                                                                                                                               |
| ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `seconds`     | The maximum query time. Queries longer than this are killed. <br />To disable this setting, you can either set the maximum time to 0 or use the `RESET` keyword (e.g., `SET MAXTIME RESET;`). |

### SET PARALLELISM

Sets a limit on the number of cores on each CPU that can be allocated to running the query. Applies only to the statement object that executed the command.

The `parallelism` value limits a query to running on the specified number of cores on each CPU.

**Syntax**

```shell
SET PARALLELISM parallelism 
```

| **Parameter** | **Description**                                                                                                                                                                                                    |
| ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `parallelism` | Limits a query to running on a specified number of cores on each CPU. <br />To disable this setting, you can either set the `parallelism` value to -1 or use the `RESET` keyword (e.g., `SET PARALLELISM RESET;`). |

### SET PRIORITY

Sets the scheduling priority to use for queries. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET PRIORITY priority
```

| **Parameter** | **Description**                                                                                                                                                                                |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `priority`    | The scheduling priority to use for queries. <br />Set from 0 to 100. To disable this setting, you can either set the priority to -1 or use the `RESET` keyword. (e.g., `SET PRIORITY RESET;`). |

### SET SCHEMA

Changes the default schema for tables. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET SCHEMA schema
```

| **Parameter** | **Description**                     |
| ------------- | ----------------------------------- |
| `schema`      | The default schema for new tables.  |

### SET SERVICECLASS

Limits a query to using the specified service class. Applies only to the statement object that executed the command.

**Syntax**

```shell
SET SERVICECLASS service_class_name
```

| **Parameter**        | **Description**                                                                                                                                        |
| -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `service_class_name` | The service class that a query is limited to using. <br />To disable this setting, you can use the `RESET` keyword. (e.g., `SET SERVICECLASS RESET;`). |

### SOURCE

Reads and executes commands found in the specified file.

**Syntax**

```shell
SOURCE filename
```

| **Parameter** | **Description**           |
| ------------- | ------------------------- |
| `filename`    | A valid filename or path. |

### TIMING

Enables or disables reporting the execution time of each query.

**Syntax**

```shell
TIMING { ON | OFF }
```

## Related Links

[JDBC Manual](<././JDBC Manual.md>)

[System Catalog](https://docs.ocient.com/system-catalog)
