Hive local installation
[huiyunltd@hadoop-senior ~] $tar xf / opt/softwares/apache-hive-0.13.1-bin.tar.gz-C / opt/app/ [huiyunltd@hadoop-senior ~] $/ opt/app/hadoop-2.5.0/sbin/start-dfs.shhadoop-senior.huiyunltd.com:50070 [huiyunltd@hadoop-senior02 ~] $/ opt/app/hadoop-2.5.0/sbin/start-yarn.sh http://hadoop-senior02.huiyunltd.com:8088[huiyunltd@hadoop -senior03 ~] $/ opt/app/hadoop-2.5.0/bin/hdfs dfs-mkdir / tmp [huiyunltd@hadoop-senior03 ~] $/ opt/app/hadoop-2.5.0/bin/hdfs dfs-chmod gallex / tmp [huiyunltd@hadoop-senior03 ~] $/ opt/app/hadoop-2.5.0/bin/hdfs dfs-mkdir-p / user/hive/warehouse [huiyunltd@hadoop-senior03 ~] $/ opt/app/hadoop-2.5.0/bin/hdfs dfs- Chmod gallex / user/hive/warehouse [huiyunltd@hadoop-senior ~] $/ opt/app/hadoop-2.5.0/sbin/mr-jobhistory-daemon.sh start historyserver/opt/app/apache-hive-0.13.1-bin/conf/hive-env.shHADOOP_HOME=/opt/app/hadoop-2.5.0export HIVE_CONF_DIR=/opt/app/apache-hive-0.13.1-bin/conf [huiyunltd@hadoop-senior ~] $/ opt/app/apache-hive- 0.13.1-bin/bin/hivehive > show databases Hive > use default;hive > create table kms_log (ip string,user string,requesturl string); hive > show tables;hive > desc kms_log;hive > select count (*) from kms_log;hive > create table student (id int,name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY'\ tkeeper; [huiyunltd@hadoop-senior ~] $touch / opt/datas/student.txtstudent.txt-1001 jack1002 mary1003 thomas1004 tomhive > load data local inpath'/ opt/datas/student.txt' into table student;hive > select * from student Hive > select * from student;hive > select id from student [huiyunltd@hadoop-senior ~] $unzip-o-d / opt/softwares/ / opt/softwares/mysql-libs.zip [huiyunltd@hadoop-senior ~] $rpm-qa | grep mysql [huiyunltd@hadoop-senior ~] $sudo rpm-e-nodeps mysql-libs-5.1.66-2.el6_3.x86_64 [huiyunltd@hadoop-senior ~] $rpm-qa | grep mysql [huiyunltd@hadoop-senior ~] $sudo rpm-ivh / opt/softwares/mysql-libs/MySQL-server-5.6 .24-1.el6.x8664.rpm [huiyunltd @ hadoop-senior ~] $sudo rpm-ivh / opt/softwares/mysql-libs/MySQL-client-5.6.24-1.el6.x8664.rpm [huiyunltd @ hadoop-senior ~] $sudo cat / root/.mysql_ secretary [huiyunltd @ hadoop-senior ~] $service mysql status [huiyunltd@hadoop-senior ~] $rpm-qa | grep MySQL [huiyunltd@hadoop-senior ~] $sudo service mysql startmysql > SET PASSWORD=PASSWORD ('123456') mysql > select User Host,Password from user Mysql > update user set Host='%' where User='root' and Host='localhost';mysql > delete from user where User='root' and Host='hadoop-senior.huiyunltd.com';mysql > delete from user where User='root' and Host='127.0.0.1';mysql > delete from user where User='root' and Host='::1' [huiyunltd@hadoop-senior ~] $sudo service mysql restart [huiyunltd@hadoop-senior ~] $cp / opt/app/apache-hive-0.13.1-bin/conf/hive-default.xml.template / opt/app/apache-hive-0.13.1-bin/conf/hive-site.xml [huiyunltd@hadoop-senior ~] $tar xf / opt/softwares/mysql-libs/mysql-connector-java-5.1.27.tar.gz-C / opt/softwares/mysql-libs/ [ Huiyunltd@hadoop-senior ~] $cp / opt/softwares/mysql-libs/mysql-connector-java-5.1.27/mysql-connector-java-5.1.27-bin.jar / opt/app/apache-hive-0.13.1-bin/lib/
-hive-site.xml- javax.jdo.option.ConnectionURL jdbc:mysql://hadoop-senior.huiyunltd.com:3306/metastore?createDatabaseIfNotExist=true JDBC connect string for a JDBC metastore javax.jdo.option .ConnectionDriverName com.mysql.jdbc.Driver Driver class name for a JDBC metastore javax.jdo.option.ConnectionUserName root username to use against metastore database javax.jdo.option.ConnectionPassword 123456 password to use against metastore database
