Spark Thrift Server Clients

With Spark Thrift server, you can use JDBC and ODBC connection interfaces that enable a variety of external tools to access Spark and run SQL queries.
  • The ODBC interface is used by BI tools (often produced by MapR partners such as Tableau or Microstrategy).
  • The JDBC interface is used by clients such as SQuirrel SQL or the Beeline simple SQL shell.

MapR Hive JDBC clients that connect to HiveServer2 can also connect to Spark Thrift server without additional configuration. For details about clients, see HiveServer2 Clients and Connecting to HiveServer2.

MapR-SASL JDBC Connection String Format

The JDBC connection string format for MapR-SASL environments is:

jdbc:hive2://<hostname>:10000/default;auth=maprsasl

Kerberos JDBC Connection String Format

The JDBC connection string format for clusters secured with Kerberos is:

jdbc:hive2://<hostname>:10000/default;principal=mapr/<FQDN@REALM>