-
创建Hive分区表,静态加载
-- 第一步: 创建分区表 -- 创建表 -- 分区表的细节: 分区列 不能跟 普通列重复 create table t_all_hero_partition( id int, name string, hp_max int, mp_max int, attack_max int, defense_max int, attack_range string, role_main string, role_assist string ) partitioned by (role string) row format delimited fields terminated by '\t' ; -- 加载数据 方式一: 静态加载 load data local inpath '/root/hero/archer.txt' into table t_all_hero_partition partition(role='archer'); load data local inpath '/root/hero/assassin.txt' into table t_all_hero_partition partition(role='assassin'); load data local inpath '/root/hero/mage.txt' into table t_all_hero_partition partition(role='mage'); load data local inpath '/root/hero/support.txt' into table t_all_hero_partition partition(role='support'); load data local inpath '/root/hero/tank.txt' into table t_
Hive分区表创建partitioned by()
于 2022-02-16 22:39:13 首次发布