怎么取消系统Win7/win8.1升级Win10
268 2023-04-03 04:33:30
<?xml-stylesheettype="text/xsl" href="configuration.xsl"?>" /> <?xml-stylesheettype="text/xsl" href="configuration.xsl"?>" />
[hadoop@master ~]$ cd /usr/local/src/hive/conf/
[hadoop@master conf]$ vi hive-site.xml
<?xmlversion="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheettype="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>Password123$</value>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</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>hive.querylog.location</name>
<value>/usr/local/src/hive/tmp</value>
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/usr/local/src/hive/tmp</value>
</property>
<property>
<name>hive.downloaded.resources.dir</name>
<value>/usr/local/src/hive/tmp/resources</value>
</property>
<property>
<name>hive.server2.logging.operation.log.location</name>
<value>/usr/local/src/hive/tmp/operation_logs</value>
</property>
</configuration>
#按Esc键退出插入模式,输入:wq!,按下回车键完成文档修改操作。
第九步:复制并更名hive-log4j2.properties.template为 hive-log4j2.properties文件:
十步:配置hive-env.sh
首先我们先复制并更名hive-env.sh.template为 hive-env.sh文件
命令 cp hive-env.sh.template hive-env.sh
1
配置文件如下:
# Set HADOOP_HOME to point to a specifichadoop install directory
# HADOOP_HOME=${bin}/../../hadoop
HADOOP_HOOME=/usr/local/hadoop-2.7.1 hdoop安装目录
# Hive Configuration Directory can becontrolled by:
# export HIVE_CONF_DIR=
export HIVE_CONF_DIR=/usr/local/hive/conf hive的配置文件目录
# Folder containing extra librariesrequired for hive compilation/execution can be controlled by:
# export HIVE_AUX_JARS_PATH=
export HIVE_AUX_JARS_PATH=/usr/local/hive/lib hive依赖的jar包目录
命令 : mysql -uroot -p
命令 : create database hive;
第十一步:启动mysql创建hive数据库
命令 : mysql -uroot -p
命令 : create database hive;
命令 :grant all privileges on *.* to'root'@'%'identified by '密码'with grant option;
命令:flush privileges; #刷新权限
上传mysql连接驱动到/usr/local/hive并解压,然后复制到hive目录中的lib中(如下图pwd路径)
复制过去后到/usr/local/hive/lib目录下查询jar包是否在lib目录下
命令 ll mysql-connector-java-5.1.47-bin.jar
命令:
在/usr/local/hive/mysql-connector-java-5.1.47目录下输入
cp mysql-connector-java-5.1.47-bin.jar/usr/local/hive/lib
进入hive的bin目录进行初始化:
命令cd /usr/local/hive/bin
初始化命令 schematool -dbType mysql -initSchema
启动hive使用命令hive即可
命令 hive
1