在集群上運(yùn)行hbase的jar程序時(shí)報(bào)找不到scan的類庫忘晤，輸入
export HADOOP_CLASSPATH=$HBASE_HOME/lib/*:$CLASSPATH
安裝mysql
1.先刪除linux上相關(guān)mysql
yum remove mysql-libs
是否繼續(xù)捏顺？[y/N]：y
2.下載 mysql57-community-release-el7-8.noarch.rpm 的 YUM 源：
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
3.安裝 mysql57-community-release-el7-8.noarch.rpm：
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
安裝完后跃闹，cd /etc/yum.repos.d/
mysql-community.repo
mysql-community-source.repo
4.安裝mysql service
yum install mysql-server
執(zhí)行y
-
安裝完畢刪除
rm -rf mysql57-community-release-el7-8.noarch.rpm
6.啟動(dòng)mysql
service mysqld start
7.查看root的默認(rèn)密碼
cat /var/log/mysqld.log | grep password
8.登錄mysql
mysql -uroot -p
9.修改root的默認(rèn)密碼
alter user 'root'@'localhost' identified by 'Www_110';
10.創(chuàng)建hive的數(shù)據(jù)庫
create database hive;
11.創(chuàng)建一個(gè)用戶次乓，一般操作不要用root
create user 'hiveme'@'%' identified by 'Www_110';
12.給剛創(chuàng)建的用戶授權(quán)
grant all on hive.* TO 'hiveme'@'%';
grant all on hive.* TO 'hiveowner'@'localhost' identified by 'Www_110';
Hive安裝
1.官網(wǎng)下載安裝包疆液，上傳到服務(wù)器颓鲜，解壓
2.配置環(huán)境變量
vim /etc/profile
export HIVE_HOME=/root/hd/apache-hive-2.3.3-bin
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HBASE_HOME/bin:$HIVE_HOME/bin
生效
source /etc/profile
3.配置hive-site.xml
先生成一個(gè)hive-site.xml
cp hive-default.xml.template hive-site.xml
刪除所有esc ggvG d
把如下信息復(fù)制到hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://ip:3306/hive?useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveowner</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>Welcowww</value>
</property>
</configuration>
4.初始化mysql
schematool -dbType mysql -initSchema
5.找不到j(luò)ar
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
Underlying cause: java.lang.ClassNotFoundException : com.mysql.jdbc.Driver
6.官網(wǎng)下載jar
https://downloads.mysql.com/archives/c-j/
下載解壓獲取jar
7.復(fù)制jar到hive到lib
scp -r /Users/hh/desktop/mysql-connector-java-5.1.46-bin.jar hh555:/root/hd/apache-hive-2.3.3-bin/lib/
8.再次重新初始化mysql
schematool -dbType mysql -initSchema
hive安裝完畢表窘！
