Home

HiveSQLClient

logo

HiveSQLClient is a free graphical standalone Java program that will allow you to connect to Hive Cluster for managing Hive objects. Supports following authentication mechanisms No Auth, User, User & Password, LDAP and Kerberos. Most of the client applications require MIT Kerberos client which needs an additional step to log in and renew to obtain a new Kerberos ticket.

A simple and lightweight program which doesn't require MIT Kerberos client to be installed on your machine and will get a Kerberos ticket automatically when you log in.

System Requirements

Tested on Windows Platform

  • Windows Vista or higher
  • Java 8 or higher

Please, feel free to send any suggestions, comments or bugs.

Check below sections for more detailed information about HiveSQLClient.

Screenshots

Screenshots

Cluster Login

graphic

Manage CLusters

graphic

Add a Cluster

graphic

Modify a Cluster

graphic

HiveSQLClient-Resultset

graphic

HiveSQLClient-QueryHistory

graphic
Download

Download HiveSQLClient

Version 1.4.6 (latest) - Download

Version 1.3.2 - Download

Changelog

Changelog

Supported Authentication Mechanisms

  • No Auth
  • User
  • User & Password
  • LDAP
  • Kerberos
  • Kerberos + LDAP

Version 1.4.6 (latest) - 1-May-2017

  • Supports No Auth, User, User & Password, LDAP authentication mechanisms
  • New feature - SQL Format and Syntax Highlighting
  • New feature - SQL Query zoom in & out
  • Supports CLI Commands set, set -v, import & export
  • Minor fixes

Version 1.3.2 - 30-Jan-2017

  • Initial release
  • Simple GUI, Lightweight and Portable
  • Easy cluster management (Add, Modify, Remove)
  • Resultset with inbuilt filter option
  • Export SQL resultset as Excel or Text file
  • Supports Hive metadata commands (USE, SHOW, DESCRIBE)
  • Supports only use, show, describe, select, insert, update, drop, truncate, merge, create, delete, explain. Future version will support more DDL, DML statements
  • Query History - (Timestamp, Cluster Source, Elapsed Time, Query, Query Result, Statement Type, Username) and inbuilt filter option
  • Color to differentiate success, failed and aborted query in Query History
  • Explain Execution the query with additional options (Dropdown Button)
  • Table List can be seen for selected database
  • Connect to multiple clusters on different windows
  • One click Connection Info
Shortcut Keystrokes

Shortcut Keystrokes

  • Execute Query - F5
  • Abort Query - F8
  • Explain Query - F6
  • SQL Format - Alt+F5
  • Explain Query - F6
  • Schema Table List - F9
  • Connection Info - F12
  • SQL Query Zoom In - Ctrl+Scroll Up
  • SQL Query Zoom Out - Ctrl+Scroll Down
  • Default SQL Query Font Size - Ctrl+Mouse Middle Click
Comments
HTML Comment Box is loading comments...
Contact
Name: *
E-mail Address: *
Subject:
Message: