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 provides instructions on 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 is also available in each download package. The following table describes the versions available per MEP release:

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 may 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