Shulou(Shulou.com)06/01 Report--

This article is about Navicat's steps to connect to hive. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

Navicat steps to connect hive:

Step 1: Install MySQL under Win.

Step 2: Install Navicat under Win.

Step 3: Start the hadoop cluster and start hive.

Step 4: Navicat connects to hive.

In the fourth step, you need to configure ssh first, then configure general properties, and finally connect.

Configure ssh to connect to spark1 node

Configure General Properties Connection hive

Note: The username and password in the general properties are hive, user and password set in the configuration file hive-site.xml in the installation directory. All of my designs are hives.

Part of the hive-site.xml configuration file:

javax.jdo.option.ConnectionUserName hive username to use against metastore database javax.jdo.option.ConnectionPassword hive password to use against metastore database

The attribute configuration in Step 4 is detailed as follows:

Spark1 is my hostname, but it can also be changed to the IP address 192.168.220.144.

After successful connection, as shown below:

Thank you for reading! The steps for Navicat to connect to hive are shared here. I hope the above content can be of some help to everyone so that everyone can learn more. If you think the article is good, you can share it so that more people can see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.