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 |
beeline
and the JDBC
driver, you may encounter the following
error:"Unsupported transaction isolation level: 4"
isolation
parameter to beeline
as
follows:bin/beeline --isolation=default