---- 建表格式
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 'prevalue_a.txt' OVERWRITE INTO TABLE databasename.CiiFcst_hotel_forecast_result_type_test partition(d='2016-01-01');
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')