Hive安装与启动 - ToB企服应用市场:ToB评测及商务社交产业平台

tar -zxvf apache-hive-3.1.3-bin.tar.gz -C /opt/module

复制代码

mv /opt/module/apache-hive-3.1.3-bin /opt/module/hive

复制代码

cp mysql-connector-java-5.1.48.jar /opt/module/hive/lib

复制代码

cp /opt/module/hive/conf/hive-deafule.xml.template hive-site.xml
或者
mv /

复制代码

<?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://hadoop102:3306/metastore?useSSL=false</value>
<description>
JDBC connect string for a JDBC metastore.
To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>Username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.metastore.schema.varification</name>
<value>false</value>
<description>
Enforce metastore schema version consistency.
True: Verify that version information stored in is compatible with one from Hive jars. Also disable automatic
schema migration attempt. Users are required to manually migrate schema after Hive upgrade which ensures
proper metastore schema migration. (Default)
False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
</description>
</property>
<property>
<name>hive.metastore.schema.verification.record.version</name>
<value>false</value>
<description>
When true the current MS version is recorded in the VERSION table. If this is disabled and verification is
enabled the MS will be unusable.
</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>location of default database for the warehouse</description>
</property>
</configuration>

复制代码

vim /etc/profile.d/my_env.sh

复制代码

#Hive
export HIVE_HOME=/opt/module/hive
export PATH=$PAH:$HIVE_HOME/bin

复制代码

source /etc/profile

复制代码

mv $HIVE_HOME/lib/log4j-slf4j-impl-2.10.0.jar $HIVE_HOME/lib/log4j-slf4j-impl-2.10.0.jar.bak

复制代码

mv $HIVE_HOME/lib/guava-19.0.jar $HIVE_HOME/lib/guava-19.0.jar.bak
cp /opt/module/hadoop-3.1.3/share/hadoop/common/lib/guava-27.0-jar /opt/module/hive/lib/

复制代码

schematool -initSchema -dbType mysql -verbose

复制代码

hive # 启动hive命令

复制代码

show databases

复制代码

show databases;

复制代码

use 数据库名;

复制代码

show tables;

复制代码

desc 表名

复制代码

# 显示数据库名，该参数默认值为false
set hive.cli.print.current.db=true;
# 显示列名，该设置会显示表名.列名，默认值为false
set hive.cli.print.header=true;
# 不显示表名，默认值为true
set hive.resultset.use.unique.column.names=false;

复制代码

<property>
<name>hive.cli.print.header</name>
<value>true</value>
<description>是否打印表头，默认值为false，即不打印</description>
</property>
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
<description>是否显示数据库名，默认值为false，即不显示</description>
</property>
<property>
<name>hive.resultset.use.unique.column.names</name>
<value>false</value>
<description>表头中是否显示表名，默认值为true，即显示</description>
</property>

复制代码

create table test (id int,name string);

复制代码

insert into test values(1,'RuoZoe');

复制代码

select * from test;

复制代码