Can navicat connect to hive?

Steps for Navicat to connect to 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 the general properties, and finally click Connect.

Configure ssh to connect to spark1 node

Configure general properties to connect to hive

Note: The username and password in the general properties are hive, and the configuration file hive-site is in the installation directory. The user and password set in xml. My configuration is all hive.

Related recommendations: "Navicat for mysql graphic tutorial"

Part of the content in the hive-site.xml configuration file:

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hive</value>
  <description>username to use against metastore database</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>hive</value>
  <description>password to use against metastore database</description>
</property>

Fourth The property configuration details in the step are as follows:

spark1 in the picture is my host name, it can also be changed directly to 192.168. The IP address 220.144.

As shown below after successful connection:

The above is the detailed content of Can navicat connect to hive?. For more information, please follow other related articles on the PHP Chinese website!