Accessing the Apache Spark™ SQL Thrift Server with the Simba JDBC driver
The Simba JDBC Driver for Spark provides a standard JDBC interface to the information stored in DataStax Enterprise with the Spark SQL Thrift Server running.
Your DSE license includes a license to use the Simba drivers.
Prerequisites
You must have a running DSE Analytics cluster with Spark enabled, and one node in the cluster running the Spark SQL Thrift Server.
Procedure
-
Download the Simba JDBC Driver for Apache Spark from the Download DataStax page.
-
Expand the ZIP file containing the driver.
-
In your JDBC application, configure the following details:
-
Add
SparkJDBC41.jarand the rest of the JAR files included in the ZIP file in your classpath. -
The JDBC driver class is
com.simba.spark.jdbc41.Driverand the JDBC data source iscom.simba.spark.jdbc41.DataSource. -
Set the connection URL to
jdbc:spark://<hostname>:<port>where<hostname>is the hostname of the node on which the Spark SQL Thrift Server is running, and<port>is the port number on which the Spark SQL Thrift Server is listening.jdbc:spark://node1.example.com:10000
-
-
For more details, see Installing Simba JDBC Driver for Apache Spark.
