Spark SQL - JDBC/ODBC

Card Puncher Data Processing

About

JDBC/ODBC means the Hive Server

Spark Jdbc

where:

URL

jdbc:hive2://localhost:10000/default

Example

With dbeaver:

Spark Sql Dbeaver

Artifacts

You need the core/common and the hive-jdbc jar.

Example for 1.2.1:

<!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-core -->
<dependency>
    <groupId>org.apache.hadoop</groupId>
    <artifactId>hadoop-core</artifactId>
    <version>1.2.1</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.spark-project.hive/hive-jdbc 
Moved to https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->
<dependency>
    <groupId>org.apache.hive</groupId>
    <artifactId>hive-jdbc</artifactId>
    <version>1.2.2</version>
</dependency>





Discover More
Card Puncher Data Processing
Spark - Sql

This section is : the SQL Grammar of Spark and the SQL Thrift Server. Spark SQL SQL is an interface to the spark Spark Sql engine that supports: all existing Hive data formats, the hive syntax...
Spark Sql Datatype
Spark SQL - Data Type

Sql Data Type in Spark. From a JDBC driver point of view



Share this page:
Follow us:
Task Runner