Defining run behavior with execution configurations
Managing execution configurations to define run behavior for a code cell.
With results visualization and profiling capability, Studio is a powerful debugging tool by executing code in a way that reproduces the settings used in their applications. When using Studio to interact with DSE, you are able to execute code written in CQL, Gremlin, or Spark SQL. Each cell language has its own set of configuration options that determine execution behavior.
Execution configurations provide different execution setups by passing a set of options that customize the run execution. Execution configurations are persistent so you can reuse them.
Cell type | Execution configuration | Settings |
---|---|---|
CQL | CL.ONE |
|
CQL | CL.Quorum |
|
CQL | CL.ALL |
|
CQL | CL.ONE.TRACE |
|
Gremlin | Transactional | Execute statement using real-time (transactional) engine for
OLTP (online transaction processing), traversal source
g . |
Gremlin | Analytic | Execute statement using analytic engine (Spark) for OLAP
(online analytical processing), traversal source
a . |
Spark SQL | Run | Execute statement with Spark SQL query engine with AlwaysOn SQL service. |
- Consistency level: ANY, ONE, TWO, THREE, QUORUM, ALL, LOCAL_QUORUM, EACH QUORUM, SERIAL, LOCAL_SERIAL, LOCAL_ONE
- Timeout (MS): milliseconds
- Max Results: number of records
- CQL Tracing: Enabled or Disabled
Procedure
-
In the upper-right corner of a code cell, hover over the play button ▶ and then click ▾
to list the existing configurations.
Tip:
- In CQL cells, the default execution configuration is CL.ONE so the play button is CL.ONE ▶.
- In Gremlin cells, the default execution configuration is Execute using real-time (transactional) engine so the play button is Real-time ▶.
- In Spark SQL cells, all statements are executed with Spark SQL query engine with AlwaysOn SQL service.
- Select Manage Configurations.
- Select an existing configuration to view settings.
-
For CQL cells only: Click + Add New Configuration
to create an execution configuration.
- Enter a self-describing Name.
- Select a Consistency Level.
- Enter a Timeout value in milliseconds.
- Enter Max Results.
- Optional: Select the CQL Tracing check box to enable CQL tracing.
-
Click Save.
New execution configurations are available to be selected from any CQL notebook cell.