今日进度

z宏远装好了，好那就开始做联系吧，

今天没有做完先发这么多，

创建表：

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;

 

导入：

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

 

 

创建表：

create table diyu(dm String, dmms String)ROW format delimited fields terminated by ',' STORED AS TEXTFILE;

导入：

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

 

 

 

 

 

创建表:

 

create table aa_19(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;

 

 

插入数据：

 

insert into table aa_19 select aa_2019.ID as ID , aa_2019.QA04 as QA04, aa_2019.QA05 as QA05, aa_2019.QA07 as QA07, aa_2019.QA15 as QA15, aa_2019.QA19 as QA19, aa_2019.Hangye as Hangye, aa_2019.QB03 as QB03,aa_2019.QB03ONE as QB03ONE, aa_2019.QB03TWO as QB03TWO, aa_2019.QB03_1 as QB03_1, aa_2019.QB06 as QB06, aa_2019.QB16 as QB16, aa_2019.QB16V as QB16V, aa_2019.Gaoxin as Gaoxin, aa_2019.QB16_1 as QB16_1, aa_2019.QB16_1V as QB16_1V, aa_2019.QC02 as QC02, aa_2019.QC05_0 as QC05_0, aa_2019.QC24 as QC24, aa_2019.QC40 as QC40, aa_2019.QD01 as QD01, aa_2019.QD28 as QD28, aa_2019.QJ09 as QJ09, aa_2019.QJ20 as QJ20, aa_2019.QJ55 as QJ55, aa_2019.QJ74 as QJ74, concat(aa_2019.QA19,diyu.dmms) as Diyu, aa_2019.SYEAR as SYEAR from aa_2019 join diyu on (aa_2019.QA19 =diyu.dm)