...

 HIVE-11488 (Hive 2.0.0) adds the support of logging queryId and sessionId to HiveServer2 log file. To enable that, edit/add %X{queryId} and %X{sessionId} to the pattern format string of the logging configuration file.

Cancelling the query

When users enter CTRL+C on the BeeLine shell and if there is a query which is running at the same time, BeeLine attempts to cancel the query while closing the socket connection to Hiveserver2. This behavior is enabled only when hive.server2.close.session.on.disconnect is set to true. Starting from from Hive 2.2.0 (HIVE-15626) BeeLine does not exit the command line shell when the running query is being cancelled as user enters {{CTRL+C}}. If the user wishes to exit the shell they can enter CTRL+C for the second time while the query is being cancelled. However, if there is no query currently running, the first CTRL+C will exit the BeeLine shell. This behavior is similar to how HiveCLI handles CTRL+C. !quit is the recommended command to exit the BeeLine shell.

JDBC

HiveServer2 has a JDBC driver. It supports both embedded and remote access to HiveServer2. Remote HiveServer2 mode is recommended for production use, as it is more secure and doesn't require direct HDFS/metastore access to be granted for users.

...