hive

hive的执行命令

beeline的使用规则

  1. 需要配置hiveserver2
hive的配置文件：hive-site.xml
<property> 
    <name>hive.server2.authentication</name> 
    <value>NONE</value> 
</property> 
<property> 
    <name>hive.server2.thrift.bind.host</name> 
    <value>node1</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>root</value> 
    <description>Username to use against thrift client</description> 
</property> 
<property> 
    <name>hive.server2.thrift.client.password</name> 
    <value>root</value> 
    <description>Password to use against thrift client</description> 
</property>

hadoop的配置文件：core-site.xml
<property> 
    <name>hadoop.proxyuser.root.hosts</name> 
    <value>*</value> 
</property> 
<property> 
    <name>hadoop.proxyuser.root.groups</name> 
    <value>*</value> 
</property>
  1. 启动hiveserver2
    hiveserver2 &
    hive --service hiveserver2 &
    在后台输入：nohup hiveserver2 1>xxx.log 2>&1 &
  2. beeline的使用
beeline
!connect jdbc:hive2://node1:10000
用户名：root
密码：root

DBeaver使用

将下面的包作为驱动导入DBeaver中即可

[root@node1 jdbc]# pwd
/opt/app/hive-2.3.8/jdbc
[root@node1 jdbc]# ls
hive-jdbc-2.3.8-standalone.jar
posted @ 2022-08-01 11:53  jsqup  阅读(26)  评论(0)    收藏  举报