hive_dml 数据操作语言:
hive_dml 数据操作语言:
首先创建表:create table dept_count(num int) partitioned by (dname string)
insert: insert into table dept_count partition (dname='销售部') select count(1) from t_emp where dept_name='销售部' group by dept_name;
import/export(导入/导出):
export table t_emp to '/user/input/emp.txt'
将数据导入到指定路径中