Database Reference
In-Depth Information
Driver: spark-assembly
(
version 1.2.0-SNAPSHOT
)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:10000> show tables
;
+---------+
|
result
|
+---------+
|
pokes
|
+---------+
1
row selected
(
1.182 seconds
)
0: jdbc:hive2://localhost:10000>
Figure 9-3. Launching the JDBC server and connecting a Beeline client
When we start the JDBC server, it goes into the background and
directs all of its output to a logfile. If you encounter issues with
queries you run against the JDBC server, check out the logs for
more complete error messages.
Many external tools can also connect to Spark SQL via its ODBC driver. The Spark
SQL ODBC driver is produced by
Simba
and can be downloaded from various Spark
vendors (e.g., Databricks Cloud, Datastax, and MapR). It is commonly used by busi‐
ness intelligence (BI) tools such as Microstrategy or Tableau; check with your tool
about how it can connect to Spark SQL. In addition, most BI tools that have
