1.加载数据到表中
LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename
[PARTITION (partcol1=val1, partcol2=val2 ...)]
2.查看表信息
//只有简单的信息
desc database.tablename
//格式化后的详细信息
desc formatted tablename
//查看扩展信息
desc external tablename
3.创建分区表
create [external] table employees(id int ,name string,age int)
comment 'employees home adress'
partitioned by (province string,city string);
4.向分区表插入数据
intsert into table employees partition(province='henan',city='zhumadian')
values(1,'zhagnsan',23),(2,'zhagnsan',23);
5.在hive中执行宿主机命令
//命令前加!
//减少命令行和hive的切换
$hive>!ls;
$hive>!clear;
//查看dfs系统
$hive>dfs -ls