Hadoop Hive-2.3.5 installation

hadoop hive-2.3.5 installation:

Unzip the file: [[email protected] opt]# tar -zxvf apache-hive-2.3.5-bin.tar.gz -C /opt

Establish a soft connection: [[email protected] opt]# ln -s apache-hive-2.3.5-bin/ hive

Enter the lib file: add maven Drag the mysql file in

Copy a file: [[emailprotected] conf]# cp hive-default.xml.template hive-site.xml

Modify the hive file: change the original Only the following picture is left for file deletion:

Add configuration file:

javax.jdo.option.ConnectionURL

< span>jdbc:mysql://192.168.56.103:3306/hive< /span>

span>

< span class="md-expand">

< span class="md-tag">javax.jdo.option.ConnectionDriverName span>

< span class="md-line md-end-block">< span>com.mysql.jdbc.Driver< /span>

span> span>

< span>< span class="md-tag"> < /span>

< span class="md-line md-end-block"> javax.jdo.option.ConnectionUserName span>

< span>root< /span>< /span>

< /span>< /span>

< span>< span class="md-tag"> < /span> span>

javax.jdo.option.ConnectionPassword< /span>< /span>

< span> ok span>< /span>< /span>

< span> span> span>

< span>< span class="md-tag"> span> span>

Modify environment variables: (note the $ before PATH/HIVE)

export HIVE_HOME=/usr/soft/hive2.3.5

< p>export PATH=$PATH:$HIVE_HOME/bin

Activate: source /etc/profile

Create in sqlyog: hive database

In the conf file Next initialization: schematool -dbType mysql -initSchema

Check whether there are tables in the hive database in sqlyog.

This is OK!