下载安装包
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 Parameter | Description |
---|---|
hive.metastore.warehouse.dir | URI of the default location for native tables |
Config Param | Config Value | Comment |
---|---|---|
javax.jdo.option.ConnectionURL | jdbc:mysql://host name/database name?createDatabaseIfNotExist=true | metadata is stored in a MySQL server |
javax.jdo.option.ConnectionDriverName | com.mysql.jdbc.Driver | MySQL JDBC driver class |
javax.jdo.option.ConnectionUserName | username | user name for connecting to MySQL server |
javax.jdo.option.ConnectionPassword | password | password 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/*