[HIVE-17483] HS2 kill command to kill queries using query id

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: HiveServer2
• Labels: TODOC3.0

Release Note

In HiveConnection -
static List<JdbcConnectionParams> getAllUrls(String zookeeperBasedHS2Url)
You can call
JdbcConnectionParams.toString() to get the actual URL

In HiveStatement -
You can get query id of a running query using -
String getQueryId()

You can kill hive queries using
"KILL QUERY <queryid1> <queryid2>"

• Assignee: Teddy Choi
• Reporter: Thejas Nair
• Created: 08/Sep/17 00:50
• Updated: 25/Oct/19 14:58
• Resolved: 26/Sep/17 21:07

Description

For administrators, it is important to be able to kill queries if required.
Currently, there is no clean way to do it.
It would help to have a "kill query <query id>" command that can be run using odbc/jdbc against a HiveServer2 instance, to kill a query with that queryid running in that instance.
Authorization will have to be done to ensure that the user that is invoking the API is allowed to perform this action.
In case of SQL std authorization, this would require admin role.

Issue Links

• causes: HIVE-18463 Typo in the JdbcConnectionParams constructor
• relates to: RANGER-1851 Enhance Ranger Hive Plugin to support authorization for KILL QUERY command
• links to: Review Board

Sub-Tasks

• Utility method to get list of all HS2 direct URIs from ZK URI: Open
• kill command to kill queries using query id: Open
• authorization of kill command: Open