1 下载安装 1.1 这里选择安装的是3.1.2,使用下面命令进行下载:
# cd ~/software wget http://mirror.bit.edu.cn/apache/hive/hive-3.1.2/apache-hive-3.1.2-bin.tar.gz 1.2 解压重命名:tar -xzvf apache-hive-3.1.2-bin.tar.gz mv apache-hive-3.1.2-bin.tar.gz hive 1.3 配置环境变量:使用vim编辑~/.bashrc文件,加入以下配置(目录换成自己的安装目录):
# hive home /software/hive export HIVE_HOME=/software/hive export PATH=$PATH:$HIVE_HOME/bin 使用source命令使配置生效:source ~/.bashrc可以使用echo $PATH 输出查看是否正确 2 简单配置 2.1 配置hive-env.sh文件位置:$HIVE_HOME/hive/conf/hive-env.sh.template命令:
cd /software/hive/conf # 复制并重命名 cp hive-env.sh.template hive-env.sh vim hive-env.sh
配置如下:
# 相应的目录换成自己的 # hadoop 目录 HADOOP_HOME=/software/hadoop
# hive 配置目录 export HIVE_CONF_DIR=/software/hive/conf
# hive 的lib目录 export HIVE_AUX_JARS_PATH=/software/hive/lib 2.2 创建并配置hive-site.xml文件位置:$HIVE_HOME/hive/conf/命令:cd /software/hive/conf # 会自动创建 vim hive-site.xml 配置 :<?xml version="1.0" encoding="UTF-8" standalone="no"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <!-- jdbc-url --> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false</value> </property> <!-- jdbc-driver --> <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>*******</value> </property> <property> <name>datanucleus.readOnlyDatastore</name> <value>false</value> </property> <property> <name>datanucleus.fixedDatastore</name> <value>false</value> </property> <property> <name>datanucleus.autoCreateSchema</name> <value>true</value> </property> <property> <name>datanucleus.schema.autoCreateAll</name> <value>true</value> </property> <property> <name>datanucleus.autoCreateTables</name> <value>true</value> </property> <property> <name>datanucleus.autoCreateColumns</name> <value>true</value> </property> <property> <name>hive.metastore.local</name> <value>true</value> </property> <!-- 显示表的列名 --> <property> <name>hive.cli.print.header</name> <value>true</value> </property> <!-- 显示数据库名称 --> <property> <name>hive.cli.print.current.db</name> <value>true</value> </property> <property> <name>hive.exec.local.scratchdir</name> <value>/usr/local/hive</value> <description>Local scratch space for Hive jobs</description> </property> <!-- 自定义目录start --> <property> <name>hive.downloaded.resources.dir</name> <value>/usr/local/hive/hive-downloaded-addDir/</value> <description>Temporary local directory for added resources in the remote file system.</description> </property> <property> <name>hive.querylog.location</name> <value>/usr/local/hive/querylog-location-addDir/</value> <description>Location of Hive run time structured log file</description> </property> <property> <name>hive.server2.logging.operation.log.location</name> <value>/usr/local/hive/hive-logging-operation-log-addDir/</value> <description>Top level directory where operation logs are stored if logging functionality is enabled</description> </property> <!-- 自定义目录end --> </configuration> 2.3 格式化数据库及验证# 格式化数据库 schematool -dbType mysql -initSchema
# 启动hive hive
# 查看数据库 hive> show databases; Tips 1. 如报错显示没有数据库连接驱动则下载mysql驱动包到hive目录下的lib目录下
cd /software/hive/lib wget http://central.maven.org/maven2/mysql/mysql-connector-java/6.0.6/mysql-connector-java-6.0.6.jar 2.自定义hive的连接用户名和密码http://www./article/1872402467/
|