安装节点划分节点名称Hive服务器Hive客户端MySQLnode1★node2★node3★下载https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-3.1.2/解压tar -zxvf ./apache-hive-3.1.2-bin.tar.gz mv apache-hive-3.1.2-bin hive-3.1.2配置配置node1、node3两台节点的Hive环境变量vim /etc/profile export HIVE_HOME/software/hive-3.1.2/ export PATH$PATH:$HIVE_HOME/bin #source 生效 source /etc/profile在node1节点$HIVE_HOME/conf下创建hive-site.xml并配置configuration property namehive.metastore.warehouse.dir/name value/user/hive/warehouse/value /property property namejavax.jdo.option.ConnectionURL/name valuejdbc:mysql://node2:3306/hive?createDatabaseIfNotExisttrueamp;useSSLfalse/value /property property namejavax.jdo.option.ConnectionDriverName/name valuecom.mysql.jdbc.Driver/value /property property namejavax.jdo.option.ConnectionUserName/name valueroot/value /property property namejavax.jdo.option.ConnectionPassword/name value123456/value /property /configuration在node3节点$HIVE_HOME/conf/中创建hive-site.xml并配置configuration property namehive.metastore.warehouse.dir/name value/user/hive/warehouse/value /property property namehive.metastore.local/name valuefalse/value /property property namehive.metastore.uris/name valuethrift://node1:9083/value /property /configurationnode1、node3节点删除$HIVE_HOME/lib下“guava”包使用Hadoop下的包替换这一步操作是因为hadoop版本较#删除Hive lib目录下“guava-19.0.jar ”包 [rootnode1 ~]# rm -rf /software/hive-3.1.2/lib/guava-19.0.jar [rootnode3 ~]# rm -rf /software/hive-3.1.2/lib/guava-19.0.jar #将Hadoop lib下的“guava”包拷贝到Hive lib目录下 [rootnode1 ~]# cp /software/hadoop-3.1.4/share/hadoop/common/lib/guava-27.0-jre.jar /software/hive-3.1.2/lib/ [rootnode3 ~]# cp /software/hadoop-3.1.4/share/hadoop/common/lib/guava-27.0-jre.jar /software/hive-3.1.2/lib/将“mysql-connector-java-5.1.47.jar”驱动包上传到node1 node3节点的$HIVE_HOME/lib目录下在node1节点中初始化Hive#初始化hive,hive2.x版本后都需要初始化 [rootnode1 ~]# schematool -dbType mysql -initSchema在服务端和客户端操作Hive这里node1是服务端 node3是客户端。先启动hdfs才能使用hive#在node1启动Hive metastore [rootnode1 hadoop]# hive --service metastore #在node1中登录Hive 创建表test(需要先启动hdfs) [rootnode1 conf]# hive hive create table test (id int,name string,age int ) row format delimited fields terminated by \t; #向表test中插入数据 hive insert into test values(1,zs,18); #在node3上登录Hive客户端查看表数据 [rootnode3 lib]# hive hive select * from test; OK 1 zs 18