今日总结

数据导入

要求将样表文件中的（AA_GXJSQYDC2019）数据导入HIVE数据仓库中。分别将地域维度表导入数据仓库中。

（1）将改名且设置字符集为UTF-8后的文件上传到本地

（2）在hive中创建表aa_2019 

create table aa_2019(

ID String,

QA04 String,

QA05 String,

QA07 String,

QA15 String,

QA19 String,

Hangye String,

QB03 String,

QB03ONE String,

QB03TWO String,

QB03_1 String,

QB06 String,

QB16 String,

QB16V String,

Gaoxin String,

QB16_1 String,

QB16_1V String,

QC02 String,

QC05_0 String,

QC24 String,

QC40 String,

QD01 String,

QD28 String,

QJ09 String,

QJ20 String,

QJ55 String,

QJ74 String,

Diyu String,

SYEAR String

)ROW format delimited fields terminated by ',' STORED AS TEXTFILE;

 

将本地文件导入hive中：

 

load data local inpath '/kkb/install/apache-hive-3.1.2-bin/testdate/aa_2019.csv' into table aa_2019;

查看数据正确性：

（3）在hive中创建表diyu

create table diyu(

dm String,

dmms String

)ROW format delimited fields terminated by ',' STORED AS TEXTFILE;

 

将本地文件导入hive中：

 

load data local inpath '/kkb/install/apache-hive-3.1.2-bin/testdate/diyu.csv' into table diyu;

 

 

 

查看数据正确性：

select * from diyu limit 10;