大数据工具apache-hive-2.0.0安装.docxVIP

大数据工具apache-hive-2.0.0安装安装hive安装在hadoop的namenode上，拷贝安装文件到linux中/usr/tools/apache-hive-2.0.0-bin.tar.gz解压：tar –zxvf apache-hive-2.0.0-bin.tar.gz添加到环境变量vi /etc/profile编辑#hiveexport HIVE_HOME=/usr/tools/apache-hive-2.0.0-binexport PATH=$PATH:$HIVE_HOME/bin保存后使其生效：source /etc/profile安装mysql作为hive的Metastore首先检查mysql是否已安装：rpm -qa | grep -i mysql结果：mysql-libs-5.1.71-1.el6.x86_64删除已安装的mysqlyum -y remove mysql-libs*tar xvf MySQL-5.5.49-1.linux2.6.x86_64.rpm-bundle.tarrpm -ivh MySQL-server-5.5.49-1.linux2.6.x86_64.rpmrpm -ivh MySQL-devel-5.5.49-1.linux2.6.x86_64.rpmrpm -ivh MySQL-client-5.5.49-1.linux2.6.x86_64.rpm启动mysqlservice mysql start首次安装时，默认密码为空，可以使用如下命令修改root密码mysqladmin -u root password mypasswordmypassword 为你设定的新密码登录mysqlmysql -u root –prpm包安装的MySQL是不会安装/etc/my.cnf文件的，解决方法，只需要复制/usr/share/mysql目录下的my-huge.cnf 文件到/etc目录，并改名为my.cnf即可cp /usr/share/mysql/my-huge.cnf /etc/my.cnfmysql默认不可以远程访问，设置远程访问--GRANT ALL PRIVILEGES ON *.* TO root@%WITH GRANT OPTION;上面这句远程访问不需要密码，如果需要密码使用下面这句GRANT ALL PRIVILEGES ON *.* TO root@%IDENTIFIED BY sa WITH GRANT OPTION;使权限生效：FLUSH PRIVILEGES;设置etc/my.cnf文件，使binlog_format=mixedvi etc/my.cnf将注释掉的binlog_format=mixed这一行前面的注释去掉然后保存，重启mysql即可service mysql restart配置hive在hdfs中新建目录/user/hive/warehousehdfs dfs –mkdir /tmphdfs dfs –mkdir /userhdfs dfs –mkdir /user/hivehdfs dfs –mkdir /user/hive/warehousehadoop fs -chmod g+w/tmphadoop fs -chmod g+w/user/hive/warehouse将mysql的驱动jar包mysql-connector-java-5.1.7-bin.jar拷入hive的lib目录下面进入hive的conf目录下面复制一下hive-default.xml.template名子命名为：hive-site.xmlcp hive-default.xml.template hive-site.xmlproperty namejavax.jdo.option.ConnectionURL/name valuejdbc:mysql://127.0.0.1:3306/hive?createDatabaseIfNotExist=true/value descriptionJDBC connect string for a JDBC metastore/description /property property namejavax.jdo.option.ConnectionDriverName/name valuecom.mysql.jdbc.Driver/value descriptionDriver class name for a JDBC metastore/description /property property namejavax.jdo.option.ConnectionUserN