hive笔记

目录

0.教程

1.基础知识

2.sql

2.1.入库

2.2.insert into

2.3.查询元数据

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;