1. Meet Minimum System Requirements

Connect to the host machine where you plan to deploy PostgreSQL instance and from a terminal window, type:

Start the instance. For RHEL and CentOS:

/etc/init.d/postgresql start

	Note
	For some newer versions of PostgreSQL, you might need to execute the following command: /etc/init.d/postgresql initdb

Reconfigure PostgreSQL server:

Create users for PostgreSQL server:

echo "CREATE DATABASE $dbname;" | psql -U postgres
echo "CREATE USER $user WITH PASSWORD '$passwd';" | psql -U postgres
echo "GRANT ALL PRIVILEGES ON DATABASE $dbname TO $user;" | psql -U postgres 

	Note
	For access to Hive metastore, create hive_dbuser and for access to Oozie metastore, create oozie_dbuser.

On the Hive Metastore host, install the connector.

Load the Hive schema:

psql -U $HIVEUSER -d $HIVEDATABASE
\connect $HIVEDATABASE;
\i hive-schema-0.13.0.postgres.sql;

	Note
	The Hive schema is located at /usr/lib/hive/scripts/metastore/upgrade/postgres.

Connect to the host machine you plan to use for Hive and HCatalog.

Install MySQL server. From a terminal window, type:

For RHEL/CentOS/Oracle Linux:

yum install mysql-server

For SLES:

zypper install mysql-server

For Ubuntu:

apt-get install mysql-server

Start the instance.

For RHEL/CentOS/Oracle Linux:

/etc/init.d/mysqld start 

For SLES:

/etc/init.d/mysqld start

For Ubuntu:

/etc/init.d/mysql start

Set the root user password using the following command format:

mysqladmin -u root password $mysqlpassword

For example, to set the password to "root":

mysqladmin -u root password root

Remove unnecessary information from log and STDOUT.

mysqladmin -u root 2>&1 >/dev/null

Now that the root password has been set, you can use the following command to log in to MySQL as root:

mysql -u root -proot

As root, create the “dbuser” and grant it adequate privileges. This user provides access to the Hive metastore. Use the following series of commands (shown here with the returned responses) to create "dbuser" with password "dbuser".

[root@c6402 /]# mysql -u root -proot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'dbuser';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'dbuser'@'%' IDENTIFIED BY 'dbuser';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql>

Use the exit command to exit MySQL.

You should now be able to reconnect to the database as "dbuser" using the following command:

mysql -u dbuser -pdbuser

After testing the "dbuser" login, use the exit command to exit MySQL.

Install the MySQL connector JAR file.

Load the Hive database schema.

mysql $HIVEUSER/$HIVEPASSWORD < hive-schema-0.13.0.mysql.sql

On the Hive Metastore host, install the appropriate JDBC .jar file.

Create a user for Hive and grant it permissions.

Load the Hive database schema.

sqlplus $HIVEUSER/$HIVEPASSWORD < hive-schema-0.13.0.oracle.sql

Check the version. From a terminal window, type:

java -version

(Optional) Uninstall the Java package if the JDK version is less than 7.

rpm -qa | grep java
yum remove {java-1.*}

(Optional) Verify that the default Java package is uninstalled.

which java

Navigate to the usr/java folder. If this folder does not already exist, create the folder:

mkdir usr/java
cd usr/java

Download the Oracle 64-bit JDK (jdk-7u51-linux-x64.tar.gz) from the Oracle download site. Open a web browser and navigate to http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html.

Accept the license agreement and download the file labeled "jdk-7u51-linux-x64.tar.gz".

	Note
	The label on the download page is "jdk-7u51-linux-x64.tar.gz", but the actual name of the file is "jdk-7u51-linux-x64.gz".

Copy the downloaded jdk-7u51-linux-x64.gz file to the /usr/java folder.

Navigate to the /usr/java folder and extract the jdk-7u51-linux-x64.gz file.

cd /usr/java
tar zxvf jdk-7u51-linux-x64.gz

The JDK files will be extracted into a usr/java/jdk1.7.0_51 directory.

Create a symbolic link (symlink) to the JDK.

ln -s /usr/java/jdk1.7.0_51 /usr/java/default

Set the JAVA_HOME and PATH environment variables.

export JAVA_HOME=/usr/java/default
export PATH=$JAVA_HOME/bin:$PATH

Verify that Java is installed in your environment by running the following command:

java -version

You should see the following output:

java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b18)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

Check the version. From a terminal window, type:

java -version

Optional - Uninstall the Java package if the JDK version is less than v1.6 update 31.

rpm -qa | grep java
yum remove {java-1.*}

Optional - Verify that the default Java package is uninstalled.

which java

Download the Oracle 64-bit JDK (jdk-6u31-linux-x64.bin) from the Oracle download site. Open a web browser and navigate to http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html.

Accept the license agreement and download jdk-6u31-linux-x64.bin to a temporary directory ($JDK_download_directory).

Change directory to the location where you downloaded the JDK and run the install.

mkdir /usr/jdk1.6.0_31
cd /usr/jdk1.6.0_31
chmod u+x $JDK_download_directory/jdk-6u31-linux-x64.bin
./$JDK_download_directory/jdk-6u31-linux-x64.bin 

Create symbolic links (symlinks) to the JDK.

mkdir /usr/java
ln -s /usr/jdk1.6.0_31/jdk1.6.0_31 /usr/java/default
ln -s /usr/java/default/bin/java /usr/bin/java

Set up your environment to define JAVA_HOME to put the Java Virtual Machine and the Java compiler on your path.

export JAVA_HOME=/usr/java/default
export PATH=$JAVA_HOME/bin:$PATH

Verify if Java is installed in your environment. Execute the following from the command line console:

java -version

You should see the following output:

java version "1.6.0_31"
Java(TM) SE Runtime Environment (build 1.6.0_31-b04)
Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01, mixed mode)

Check the version. From a terminal window, type:

java -version

(Optional) Uninstall the Java package if the JDK version is less than 7.

rpm -qa | grep java
yum remove {java-1.*}

(Optional) Verify that the default Java package is uninstalled.

which java

Download OpenJDK 7 RPMs. From the command-line, run:

yum install java-1.7.0-openjdk java-1.7.0-openjdk-devel

Create symbolic links (symlinks) to the JDK.

mkdir /usr/java
ln -s /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.51.x86_64 /usr/java/default
ln -s /usr/java/default/bin/java /usr/bin/java

Set up your environment to define JAVA_HOME to put the Java Virtual Machine and the Java compiler on your path.

export JAVA_HOME=/usr/java/default
export PATH=$JAVA_HOME/bin:$PATH

Verify if Java is installed in your environment. Execute the following from the command-line console:

java -version

You should see output similar to the following:

openjdk version "1.7.0"
OpenJDK Runtime Environment (build 1.7.0)
OpenJDK Client VM (build 20.6-b01, mixed mode)