关于Hive分区表

    科技2022-07-13  131

    一、建立分区表: create table part_tbl( id string) partitioned by (dt string) row format delimited fields terminated by “\t”; 二、给分区表添加分区: alter table part_tbl add partition (dt = 20201010); 三、从本地加载数据的时候添加分区: load data local inpath “/data/data.txt” into table part_tbl partition (dt = 20200303);

    Processed: 0.012, SQL: 8