1.建表

drop table if exists ods.ods_t_aircompany_inc_day;

CREATE EXTERNAL TABLE IF NOT EXISTS ods.ods_t_aircompany_inc_day (

  data STRING

)

COMMENT '民航数据增量数据（天）'

PARTITIONED BY (dt STRING)

ROW FORMAT DELIMITED

  LINES TERMINATED BY '\n'

STORED AS TEXTFILE

LOCATION '/upload/minhang';

2.手动创建分区

alter table ods.ods_t_aircompany_inc_day drop if exists partition (dt='20240203');

alter table ods.ods_t_aircompany_inc_day add partition (dt='20240203');

3.hdfs数据路径