1. Hive’s official website introduces three graphical interface tools that can connect to HiveServer2 through JDBC in Windows, including: SQuirrel SQL Client, Oracle SQL Developer and DbVisualizer.
2.SQuirrel SQL Client
Download the latest squirrel-sql from http://squirrel-sql.sourceforge.net/, version 3.7.1, and open it after installation.
1. Create a new Driver, and pay attention to adding the Hive and Hadoop jar packages that the operation depends on
I use version 3.9.3. To test successfully, you need to copy all the packages under lib in hive and add them in
2 Oracle SQL Developer
from http ://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html download SQL Developer 4.1.5 and unzip it;
from http://www.cloudera.com/downloads/ connectors/hive/jdbc/2-5-15.htmlDownload Hive JDBC Driver for Oracle SQL Developer, unzip it, enter the unzipped directory, and unzip Cloudera_HiveJDBC4_2.5.15.1040.zip.
Open sqldeveloper.exe, click “Tools” -> “Preferences”, in “Database” -> “Third-party JDBC driver”, add Hive JDBC driver
3 DbVisualizer
DbVisualizer I haven’t tried it, it should be similar
The second and the third have not been tried. Please understand the deficiencies