DBeaver连接Hive

一、配置hiveserver2的用户名和密码

hive-site.xml(如果配置的话需要配置一个对HDFS有读写权限的用户,不然连接后不能创建数据库和表)

   <!--hiveserver2-->
   <property>
        <name>hive.server2.authentication</name>
        <value>NONE</value>
    </property>
    <property>
            <name>hive.server2.thrift.bind.host</name>
            <value>hadoop</value>
    </property>
    <property>
             <name>hive.server2.thrift.port</name>
             <value>10000</value>
             <description>TCP port number to listen on, default 10000</description>
     </property>

    <property>
            <name>hive.server2.thrift.http.port</name>
            <value>10001</value>
    </property>

    <property>
            <name>hive.server2.thrift.client.user</name>
            <value>hadoop</value>
            <description>Username to use against thrift client</description>
    </property>
    <property>
            <name>hive.server2.thrift.client.password</name>
            <value>hadoop</value>
            <description>Password to use against thrift client</description>
    </property>

也可以设置为不用用户名和密码

<property>
    <name>hive.server2.authentication</name>
    <value>NONE</value>
  </property>

core-site.xml

<property>
        <name>hadoop.proxyuser.root.hosts</name>
        <value>*</value>
    </property>
    <property>
        <name>hadoop.proxyuser.root.groups</name>
        <value>*</value>
    </property>

启动hiveserver2

[hadoop@JD logs]$ nohup hiveserver2 > hive.log 2>&1 &
[2] 21990

启动beeline测试连接

使用绝对路径避免与Spark中的beeline冲突

[hadoop@JD ~]$ $HIVE_HOME/bin/beeline
ls: cannot access /home/hadoop/app/spark-2.4.2-bin-2.6.0-cdh5.7.0/lib/spark-assembly-*.jar: No such file or directory
which: no hbase in (/home/hadoop/app/spark-2.4.2-bin-2.6.0-cdh5.7.0/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/kafka_2.11-0.10.1.0/bin:/home/hadoop/app/hadoop-2.6.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0-cdh5.7.0/sbin:/home/hadoop/app/zookeeper-3.4.5-cdh5.7.0/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/usr/java/jdk1.8.0_201/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hadoop/.local/bin:/home/hadoop/bin)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
beeline>

用户名和密码就是在hive-site.xml中配置的

beeline> !connect jdbc:hive2://JD:10000
scan complete in 32ms
Connecting to jdbc:hive2://JD:10000
Enter username for jdbc:hive2://JD:10000: hadoop
Enter password for jdbc:hive2://JD:10000: ******
Connected to: Apache Hive (version 1.1.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://JD:10000> show databases;
+----------------+--+
| database_name  |
+----------------+--+
| default        |
+----------------+--+
1 row selected (0.244 seconds)