create table ipbc(
ip string
)partitioned by(ds string)
row format delimited fields terminated by '\t';
load data local inpath '/root/ztj/ipbc0705.txt' into table ipbc partition (ds='2020-07-05');
insert into table ipbc partition (ds='20200706') select ip from ipbc where ds='20200702';
hive分区表的创建和数据加载
最新推荐文章于 2024-05-07 06:28:02 发布