HiveSQLClient
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.
Download HiveSQLClient
Version 1.4.6 (latest) - Download
Version 1.3.2 - Download
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