hive 配置

曾经终败给现在 2022-06-06 06:44 178阅读 0赞

hive下载地址[https://mirrors.tuna.tsinghua.edu.cn/apache/hive/][https_mirrors.tuna.tsinghua.edu.cn_apache_hive]  
解压到/usr/local 改名为hive

更改拥有者  
sudo chown -R hadoop:hadoop hive

配置环境

export HIVE_HOME=/usr/local/hive
    export PATH=$PATH:$HIVE_HOME/bin

在hive/conf下新建文件hive-site.xml  
将 hive-env.sh.template 改名为 hive-default.xml  
编辑：vi hive-site.xml  
内容如下：

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
    <configuration>
        <property>
        <name>javax.jdo.option.ConnectionURL</name>
            <value>jdbc:mysql://127.0.0.1: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>123456</value>
        </property>
    </configuration>

安装mysql  
sudo yum install mysql-server

重启sudo service mysqld restart

下载mysql驱动[https://dev.mysql.com/downloads/connector/j/][https_dev.mysql.com_downloads_connector_j]  
解压后将mysql-connector-java-5.1.42-bin.jar拷贝到/usr/local/hive/lib目录下

进入mysql命令下(mysql服务先要开启)  
mysql -u root -p

将mysql权限赋给hive  
grant all on *.* to hive@localhost identified by ‘hive’;

刷新权限关系  
flush privileges

退出mysql命令在终端输入hive即可进入hive命令下

[https_mirrors.tuna.tsinghua.edu.cn_apache_hive]: https://mirrors.tuna.tsinghua.edu.cn/apache/hive/
[https_dev.mysql.com_downloads_connector_j]: https://dev.mysql.com/downloads/connector/j/