dse spark-sql
Starts the Spark SQL shell in DSE to interactively perform Spark SQL queries.
The Spark SQL shell in DSE automatically creates a Spark session and connects to the Spark SQL Thrift server to handle the underlying JDBC connections. See Using Spark SQL to query data.
Synopsis
dse spark-sql
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
<`Italics>` |
Variable value. Replace with a valid option or user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
|
Set, list, map, or tuple.
Angle brackets ( |
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
This command accepts no parameters.
Examples
Start the Spark SQL shell
dse spark-sql
The log file is at /home/ubuntu/.spark-sql-shell.log spark-sql>
At the spark-sql prompt, you can interactively perform Spark SQL queries.