目录
0.教程
Hive SQL 简介 | Hive SQL 教程 - 盖若
1.基础知识
https://www.cnblogs.com/maiyoums/p/14402616.html
2.sql
2.1.入库
load data local inpath '/data1/sv_classify_20220609135750.txt' into table tb_c_in_sv_classify_m partition(statis_ym='202206')
2.2.insert into
insert into sv_classify partition(statis_ymd='20220616', statis_ymhd='1',prov_id='1',is_identified='1')
values('aDc8Omc7aDY4Mzg6NmRp','G0004','123','5','94','10288567890'),('NmU8Omk8aWc4NWVoZzho','G0004','123','5','94','10288567890');
2.3.查询元数据
select * from DBS;
select * from TBLS;