APACHE HIVE TM

下载安装包

wget https://mirrors.bfsu.edu.cn/apache/hive/hive-2.3.8/apache-hive-2.3.8-bin.tar.gz
wget https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-8.0.24.tar.gz

配置环境变量

vi /etc/profile
# 环境变量配置生效
source /etc/profile

export HIVE_HOME=/bigdata/apache-hive-2.3.8-bin

配置

mv hive-default.xml.template hive-site.xml

hive-site.xml

<property>
        <name>hive.metastore.warehouse.dir</name>
        <value>/user/hive/warehouse</value>
</property>
<property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://node04/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 ParameterDescription
hive.metastore.warehouse.dirURI of the default location for native tables
Config ParamConfig ValueComment
javax.jdo.option.ConnectionURLjdbc:mysql://host name/database name?createDatabaseIfNotExist=truemetadata is stored in a MySQL server
javax.jdo.option.ConnectionDriverNamecom.mysql.jdbc.DriverMySQL JDBC driver class
javax.jdo.option.ConnectionUserNameusernameuser name for connecting to MySQL server
javax.jdo.option.ConnectionPasswordpasswordpassword for connecting to MySQL server

jar包

cd lib/
mv /bigdata/mysql-connector-java-8.0.24/mysql-connector-java-8.0.24.jar ./

初始化

第一次启动

schematool -dbType db type -initSchema

schematool -dbType mysql -initSchema

启动

hive

使用

新建表

create table tbl(id int,age int);

查看表信息(元数据)

desc formatted tbl;

插入数据

insert into tbl values(1,1);

分隔符

下载下来

hdfs dfs -get /user/hive/warehouse/tbl/*

Scroll to Top