Using Beeline

DataStax Enterprise supports the Beeline client for use with Spark SQL Thrift Server.

DataStax Enterprise supports the Beeline client for use with the Spark SQL Thrift Server:

Hive 0.13 Beeline (dse spark-beeline) is for Spark SQL Thrift Server, supported in DataStax Enterprise 4.8.0 and later releases
Hive 0.12 Beeline (dse beeline) is for HiveServer2, supported in DataStax Enterprise 4.7.x and earlier releases

Note: To show the command line help for dse spark-beeline:

dse spark-beeline --help

Procedure

Start the server by entering the dse spark-sql-thriftserver start command as a user with permissions to write to the Spark directories.

To override the default settings for the server, pass in the configuration property using the --hiveconf option. See the HiveServer2 documentation for a complete list of configuration properties.
```
dse spark-sql-thriftserver start
```
By default, the server listens on port 10000 on the localhost interface on the node from which it was started. You can specify the server to start on a specific port. For example, to start the server on port 10001, use the --hiveconf hive.server2.thrift.port=10001 option. You can configure the port and bind address in resources/spark/conf/spark-env.sh: HIVE_SERVER2_THRIFT_PORT, HIVE_SERVER2_THRIFT_BIND_HOST.
```
dse spark-sql-thriftserver start --hiveconf hive.server2.thrift.port=10001
```
You can specify general Spark configuration settings by using the --conf option.
```
dse spark-sql-thrift-server start --conf spark.cores.max=4
```
In a terminal window, start Beeline for Spark SQL Thrift Server.
```
dse spark-beeline
```
The beeline prompt appears.
```
Beeline version 1.2.1.2_dse_spark by Apache Hive
beeline>
```

Connect to the server. On a single-node, development cluster for example:

beeline> !connect jdbc:hive2://localhost:10000

scan complete in 24ms
Connecting to jdbc:hive2://localhost

Enter the username and password, or hit enter if you have not set a username and password.

The hive2 prompt appears.

Connected to: Spark SQL (version 1.6.1)
Driver: Hive JDBC (version 1.2.1.2_dse_spark)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000>

Run Hive queries.

0: jdbc:hive2://localhost:10000> show databases;
+------------+--+
|   result   |
+------------+--+
| default    |
| northwind  |
+------------+--+
2 rows selected (4.728 seconds)

0: jdbc:hive2://localhost:10000> select * from keyspace.table;