创建外部表,PARQUET格式,以文件日期作为PARTITION分区
create external table if not exists TABLE_NAME (
serverReceiveTimestamp BIGINT COMMENT 'XXX',
Id STRING COMMENT 'XXX',
fileType BIGINT
) PARTITIONED BY(fileDate STRING COMMENT "yyyyMMdd")
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe';
加载分区数据
hive -e "
ALTER TABLE _TABLENAME_ ADD PARTITION(fileDate='xxxxxx') LOCATION 'hdfs_location';
"