Hive表txt文件导入

---- 建表格式
USE databasename;
CREATE TABLE CiiFcst_hotel_forecast_result_type_test(
masterhotel int COMMENT '酒店ID',
ciiquantity  double COMMENT '间夜量'
)
comment '测试表'
PARTITIONED BY(d STRING COMMENT 'date')
row format delimited fields terminated by '\t'
stored as TextFile; 

----- 导入分区数据
hive> load data local inpath 'prevalue1024.txt' into table databasename.CiiFcst_hotel_forecast_result_type_test partition(d='2016-10-24');  

----- 普通表导入
hive> load data local inpath 'city1.txt' into table databasename.CiiFrcst_City_List;

---- 删除插入

hive> load data local inpath 'prevalue1024.txt' OVERWRITE INTO TABLE databasename.CiiFcst_hotel_forecast_result_type_test partition(d='2016-01-01');
hive> load data local inpath 'prevalue_a.txt' OVERWRITE INTO TABLE databasename.CiiFcst_hotel_forecast_result_type_test partition(d='2016-01-01');

----删除分区

use databasename;

altertable CiiFcst_hotel_Cii_Monitor drop partition(dt='2016-09-04',pos='1')