hive 语句 对表的删除操作

--  删除库
drop database if exists db_name;

--  强制删除库
drop database if exists db_name cascade;

--  删除表
drop table if exists employee;

--  清空表
truncate table employee;
--  清空表，第二种方式
insert overwrite table employee select * from employee where 1=0; 

--  删除分区
alter table employee_table drop partition (stat_year_month>='2018-01-03');

--  按条件删除数据
insert overwrite table employee_table select * from employee_table where id>'180203a15f';

-- 导入表到hive中
hive -e "load data local inpath 'fraud_features_all.gz' overwrite into table yx_riskdm_tmp.tmp_anti_fraud_busext_unpartitioned;"
hive -e "insert  into table yx_riskdm_tmp.tmp_anti_fraud_busext partition(dt='${perDate}') select * from yx_riskdm_tmp.tmp_anti_fraud_busext_unpartitioned where apply_no !='apply_no';"

-- hive 导出表
hive -e "set hive.cli.print.header=true;
set hive.resultset.use.unique.column.names=false;
select * from yx_riskdm_tmp.credit_base_summary_distinct_daily " >'fraud_credit_info.txt'