Spark JDBC and ODBC Drivers

MapR provides JDBC and ODBC drivers so you can write SQL queries that access the Apache Spark data-processing engine. This section describes how to download the drivers, and install and configure them.

You can download the Spark JDBC driver from https://package.mapr.com/tools/MapR-JDBC/MapR_Spark/ and the Spark ODBC driver from https://package.mapr.com/tools/MapR-ODBC/MapR_Spark/.

After downloading the driver, refer to the documentation at Spark JDBC Driver to install and configure the JDBC driver and Spark ODBC Driver for the ODBC driver. A copy of the documentation also is available in each download package. The following table describes the driver versions available for various MEP releases:

MEP version Driver version Driver link Documentation link
JDBC version MEP 6.0.0+ 2.6.3 Spark JDBC Driver for version 2.6.3 Spark JDBC Documentation for version 2.6.3
MEP-3.0.1+ 1.1.8 Spark JDBC Driver for version 1.1.8 Spark JDBC Documentation for version 1.1.8
ODBC version MEP 6.0.0+ 2.6.1 Spark ODBC Driver for version 2.6.1 Spark ODBC Documentation for version 2.6.1
MEP-2.0.2+ 1.2.5 Spark ODBC Driver for version 1.2.5 Spark ODBC Documentation for version 1.2.5
Note: When connecting to the Spark Thrift Server using beeline and the JDBC driver, you might encounter the following error:
"Unsupported transaction isolation level: 4"
To avoid this error, pass the isolation parameter to beeline as follows:
bin/beeline --isolation=default