Ubuntu16.04 install apache-hive-2. X.x-bin.tar.gz

Pre-preparatory work:

　　Note: If the following command is not sufficient, please add sudo to the command, and the following configuration for all CQB-LENOVO-B40 please replace your hostname or localhost!!!

Installing the mysql5.x versionInstalling the hadoop2.x versionInstall hive2.x.x:Open Terminal:

Ctrl+alt+t

Download Hadoop:

wget http://mirrors.hust.edu.cn/apache/hive/hive-2.3.0/apache-hive-2.3.0-bin.tar.gz

to create the installation directory for Hadoop:

Mkdir-p/data/service/

unzip to the/data/service/directory:

TAR-ZXVF apache-hive-2.3.0-bin.tar.gz -c/data/service/

Enter The/data/service/directory:

cd/data/service/

Add the file name to Hadoop:

MvApache-hive-2.3.0-bin/Hive

into hive configuration directory

cd/data/ service/hive/conf/

< Span style= "Font-family:courier new, Courier" > < Span style= "Font-family:courier new, Courier" > configuration hive.site.xml in fact, the configuration directory does not have this file, to create our own, directly copy hive-default.xml.template this configuration file Modify the name Hive.site.xml:

CP Hive-default.xml.template hive.site.xml

configuring Hive.site.xml files with Gedit

sudo gedit/data/service/hive/conf/Hive-site.xml

Configuration:

<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>

<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>

The following configuration MySQL configuration two select one:

View MySQL version: Mysql-u root-p log in to MySQL to see the version number. Example: Server version:5.7.19 MySQL Community Server (GPL)

　　　　　　　　

mysql5.5 version:

<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>

mysql5.7 version:

<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=false</value>

<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>

<name>hive.metastore.schema.verification</name>
<value>false</value>

The following few configurations do not replicate to the penultimate line as follows:

<property>
<name>datanucleus.schema.autoCreateSchema</name>
<value>true</value>
</property>

<property>
<name>datanucleus.schema.autoCreateTables</name>
<value>true</value>
</property>

<property>
<name>datanucleus.schema.autoCreateColumns</name>

<value>true</value>
</property>

　　　　　　　　　　　　

Replace all of the ${system:java.io.tmpdir} to/tmp

Replace all of the ${system:user.name} to root

Hive.site.xml file configuration is complete.

The hive connection to MySQL requires MySQL's JDBC rack package, so we have no MySQL JDBC Rack package in the/data/service/hive/lib/directory.

Enter the Lib directory:

cd/data/service/hive/lib/

To see if a JDBC Rack package exists:

Ls-l mysql-connector-java-x.x.xx.tar.gz

If not, please download the MySQL JDBC package on the website:

sudo wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.44.tar.gz

Wait for the download to complete, unzip the JDBC package:

sudo tar zxvf mysql-connector-java-5.1.44.tar.gz

Because the extract is a directory, we only need the inside of the Mysql-connector-java-5.1.44-bin.jar on the line:

Into the directory that has been unzipped:

CD mysql-connector-java-5.1.44/

Cut Mysql-connector-java-5.1.44-bin.jar to cd/data/service/hive/lib/directory

sudo mv mysql-connector-java-5.1.44-bin.jar/data/service/hive/lib/

set environment Variables for hive:

sudo vim/etc/profile.d/hive-en.sh

　　　　

Execute the hive-en.sh environment variable:

source/etc/profile.d/hive-en.sh

Verify the hive-en.sh path location:

Echo $HIVE-home

This is the end of the configuration, and then you can start hive. you need to start Hadoop before you start hive, or you will see a deny connection:

　　　　

Terminal input hive will allow hive to run, and if successful it will enter hive> edit mode, such as:

　　　　

If hive fails to start unexpectedly--you can use the Tail-f/tmp/user directory/hive.log to see the exception.Press CTRL + C to exit hive. 　　open a terminal to MySQL, check the MySQL database, if there is a hive database to build hive success:

　　　　

Ubuntu16.04 install apache-hive-2. X.x-bin.tar.gz