hive 创建按照日期分割的表

createtable.sql

create table test_partition (
id int,
name string,
no int)
partitioned by(dt string) 
row formatdelimited 
fieldsterminated by ',' 
stored astextfile;

load data local inpath '/home/zhangxin/hive/test_hive.txt' overwrite intotabletest_partition partition (dt='2012-03-05');