hive2.1.1安装

hive2.1.1安装步骤：

    安装部署环境：

            虚拟机：VMware Workstation11.0.0 build-2305329

            操作系统：Centos6.5

            jdk:    jdk1.8.0_65

            hadoop:hadoop-2.7.1

    安装过程：下载hive安装包：下载地址：http://apache.fayea.com/hive/hive-2.1.1/

            tar -zxvf apache-hive-2.1.1-bin.tar.gz

    解压完成之后先不要做其他操作，首先替换hive的元数据库：

            安装mysql：https://my.oschina.net/u/3376452/blog/879139

            配置hive元数据库：

            第一步：如果之前有启动hive，首先删除上次运行的默认的hive数据库

                        hadoop fs -rmr /user/hive

            第二步：复制hive/conf/hive-default.xml.template为hive-site.xml

                        cp hive/conf/hive-default.xml.template hive-site.xml

                        vi hive-site.xml

            配置hive-site.xml中的信息

            <configuration>

                    <property>

                            <name>javax.jdo.option.ConnectionURL</name>

                            <value>jdbc:mysql://mrj001:3306/hive?createDatabaseIfNotExist=true</value>

                    </property>

                    <property>

                            <name>javax.jdo.option.ConnectionDriverName</name>

                            <value>com.mysql.jdbc.Driver</value>

                    </property>

                    <property>

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

                            <value>root</value>

                    </property>

                    <property>

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

                            <value>root</value>

                    </property>

            </configuration>

            第三步：导入mysql数据库驱动包到hive安装目录下的lib文件夹

                    mysql-connector-java-5.1.38-bin

            第四步：给root用户权限：

            GRANT ALL PRIVILEGES ON *.* TO 'root'@'mrj001' IDENTIFIED BY 'root' WITH GRANT OPTION;

            第五步：进入hive的bin目录下，scripts -initSchema -dbType mysql 

            第六步：登录mysql，发现有一个hive库，则配置完成

 

                

转载于:https://my.oschina.net/u/3376452/blog/879144