Ambari Learn 16_ use Ambari installation hive considerations

Before installing hive, you need to install MySQL, as shown in the following steps for installing hive: http://blog.csdn.net/wang_zhenwei/article/details/50563718
when using Ambari to install the hive process, you need to install MySQL on the machine first, the installation process is as follows: 1. Establishing a database for Ambari

# yum Install Mysql-connector-java
#  mysql-u root-p mysql>
USER ' ambari ' @ '% ' identified by ' glj887 '; 
  
   mysql> GRANT all privileges in *.* to ' ambari ' @ '% ';
mysql> CREATE USER ' ambari ' @ ' localhost ' identified by ' glj887 ';
Mysql> GRANT all privileges in *.* to ' ambari ' @ ' localhost ';
  

1 2 3 4 5 6 1 2 3 4 5-6

Change the glj887 to your MySQL root password.

Log on as a new user, Amabri,

# mysql-u ambari-p
mysql> CREATE DATABASE Amba;
mysql> use Amba;                    
Mysql> SOURCE Var/lib/ambari-server/resources/ambari-ddl-mysql-create.sql;
Mysql> exit

1 2 3 4 5 1 2 3 4 5

Where Var/lib/ambari-server/resources/ambari-ddl-mysql-create.sql is the path where Ambari-ddl-mysql-create.sql is located, generally in var/lib/ Ambari-server/resources/under. Reference: http://blog.csdn.net/sinat_28224453/article/details/51538502

Then, when the page is configured, do the following: 8.Custom services

Look at the parameters of the configuration, and finally see Hive. Mainly look at the memory configuration, such as Java heap size, according to the total memory size of the machine allocated, this cluster is to set the memory to the default value of half. These parameters can be adjusted after the cluster has been built.

After reading the other items, the validation hive.
MySQL is on master, such as Figure 6.8.2 fill in the database of the machine domain name, the five part of the advance for Hive database information to fill in the table, click Test Connection.

Reference: http://blog.csdn.net/wang_zhenwei/article/details/53083241