创建表分区
create table t_t5(id int,name string) partitioned by(country string) row format delimited fields terminated by ',';
编辑数据
上传数据
hadoop fs -put t5.txt /user/hive/warehouse/db1.db/t_t5
查看表数据
hive> select * from t_t5;
OK
Time taken: 0.064 seconds
删除原来上传的数据
hadoop fs -rm /user/hive/warehouse/db1.db/t_t5/t5.txt1
导入数据 (local INPATH)装配的是本地数据
hive> LOAD DATA local INPATH '/t5.txt' into table t_t5 partition(country='USA');
然后打开ip:50070查看