hive外部表使用分区partition

      1）创建外部表

create external table test(username String,work string) PARTITIONED BY(year String, month String, day String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/tmp/test/';

      2）修改表创建分区

alter table test add partition (year='2010', month='04', day='18') location '2010/04/18';

     ps：分区的名称不能和字段的名称重复

      3）查看外部表目录变化

[hadoop@hadoopmaster hadoop-1.0.3]$ bin/hadoop fs -mkdir /tmp/test/
[hadoop@hadoopmaster hadoop-1.0.3]$ bin/hadoop fs -ls /tmp/test/
Found 1 items
drwxr-xr-x   - hadoop supergroup          0 2012-07-03 19:17 /tmp/test/2010
[hadoop@hadoopmaster hadoop-1.0.3]$ bin/hadoop fs -ls /tmp/test/2010
Found 1 items
drwxr-xr-x   - hadoop supergroup          0 2012-07-03 19:17