hive多用户安装配置

目标：

首先分发hive文件到各个节点：

scp -r apache-hive/ root@node7-2:`pwd`

l 服务器端:conf/hive-site.xml:

 1 <?xml version="1.0"?>
 2 <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
 3 <configuration>
 4   
 7   <property>
 8     <name>hive.metastore.warehouse.dirname>
 9     <value>/data/hive/data/value>
10   property>
11   
12   <property>
13     <name>hive.metastore.localname>
14     <value>truevalue>
15   property>
16   
23   <property>
24     <name>javax.jdo.option.ConnectionURLname>
25 <value>jdbc:mysql://192.168.56.1/hive-demo?useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true&allowPublicKeyRetrieval=truevalue>
26 <-- >jdbc:mysql://node7-1:3306/hive?createDatabaseIfNotExist=truevalue> 如果mysql在服务器上，使用这个设置，本人的mysql在node7-1-->
27   property>
28   <property>
29     <name>javax.jdo.option.ConnectionDriverNamename>
30     <value>com.mysql.cj.jdbc.Drivervalue>
31   property>
32   <property>
33     <name>javax.jdo.option.ConnectionUserNamename>
34     <value>rootvalue>
35   property>
36   <property>
37     <name>javax.jdo.option.ConnectionPasswordname>
38     <value>123456value>
39   property>
40   
43   <property>
44     <name>hive.server2.webui.hostname>
45     <value>0.0.0.0value>
46   property>
47   
48   <property>
49     <name>hive.server2.webui.portname>
50     <value>10001value>
51   property>
52 configuration>

客户端:conf/hive-site.xml

 1 <?xml version="1.0"?>
 2 <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
 3 <configuration>
 4   
 5   <property>
 6     <name>hive.metastore.warehouse.dirname>
 7     <value>/data/hive/data/warehousevalue>
 8   property>
 9   
10   <property>
11     <name>hive.metastore.localname>
12     <value>falsevalue>
13   property>
14   
18   <property>
19     <name>hive.metastore.urisname>
20     <value>thrift://node7-4:9083value>
21   property>
22 configuration>

l 启动:在node-4上启动服务器端

bin/hive --service metastore
nohup bin/hive --service metastore &

l 启动:在node-2上启动客户端

bin/hive

启动服务器:

nohup bin/hiveserver2  &

访问(等待时间比较长)

http://node7-4:10001/