（超详细+亲测有效）Ubuntu18.0.4安装并配置hive-2.3.7

1
2
sudo tar -zxf ~/下载/apache-hive-2.3.7-bin.tar.gz -C /usr/local

1
2
sudo mv /usr/local/apache-hive-2.3.7-bin /usr/local/hive2.3.7

1
2
sudo gedit /etc/profile

1
2
3
export HIVE_HOME=/usr/local/hive2.3.7
export PATH=$PATH:$HIVE_HOME/bin

1
2
source /etc/profile

1
2
hive --version

1
2
cd /usr/local/hive2.3.7/conf

1
2
sudo touch hive-site.xml

1
2
sudo gedit /usr/local/hive2.3.7/conf/hive-site.xml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<configuration>
  <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=true</value>
      <description>JDBC connect string for a JDBC metastore</description>    
  </property>
  <property> 
      <name>javax.jdo.option.ConnectionDriverName</name> 
      <value>com.mysql.jdbc.Driver</value> 
      <description>Driver class name for a JDBC metastore</description>     
   </property>               

   <property> 
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>hive</value>
      <description>username to use against metastore database</description>
   </property>
   <property>  
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>hive</value>
      <description>password to use against metastore database</description>  
   </property>
</configuration>

1
2
3
4
5
cd 下载
sudo cp mysql-connector-java-5.1.45-bin.jar /usr/local/hive2.3.7/lib
cd /usr/local/hive2.3.7/lib
ls

1
2
3
cd /usr/local/hive2.3.7/bin
./schematool -dbType mysql -initSchema

1
2
./hive