Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use DataGrip to connect Hive. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

1. Download the installation package from the official website Download URL

2. installation

the first step

the second step

the third step

the fourth step

3. Enter activation code after installation

Using the installation idea diagram datagrip is similar to this

4. Configure Hive

the first step

the second step

The third step can be copied locally on the VM

jar package get link

the fourth step

Step 5:

Execute the following code on the master node (Hive service is enabled in the background)

This service cannot be connected without opening it.

[root@node01 /]# nohup hive --service hiveserver2 &

Cloned master node tests whether it can connect to the pass-through

[root@node01 /]# beelinewhich: no hbase in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/export/servers/hadoop-2.6.0-cdh6.14.0/bin:/export/servers/hive-1.1.0-cdh6.14.0//bin:/export/servers/jdk1.8.0_144/bin:/root/bin)Beeline version 1.1.0-cdh6.14.0 by Apache Hivebeeline> beeline> beeline> ! connect jdbc:hive2://node01:10000scan complete in 2msConnecting to jdbc:hive2://node01:10000Enter username for jdbc:hive2://node01:10000: rootEnter password for jdbc:hive2://node01:10000: ******Connected to: Apache Hive (version 1.1.0-cdh6.14.0)Driver: Hive JDBC (version 1.1.0-cdh6.14.0)Transaction isolation: TRANSACTION_REPEATABLE_READ0: jdbc:hive2://node01:10000>

Step 6 (Success is defined as seeing the following information)

DataGrip tutorial series:

The latest DataGrip2020.2.x crack version activation code steps detailed explanation (Mac/Windows/Linux support)

DataGrip 2020.1 Installation and Activation

About "how to use DataGrip to connect Hive" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people see.

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.