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>

2. 启动hiveserver2
   hiveserver2 &
hive --service hiveserver2 &
在后台输入：nohup hiveserver2 1>xxx.log 2>&1 &
3. 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