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 /tmp/test/2010/04
　　[hadoop@hadoopmaster hadoop-1.0.3]$ bin/hadoop fs -ls /tmp/test/2010/04
　　Found 1 items
　　drwxr-xr-x   - hadoop supergroup          0 2012-07-03 19:17 /tmp/test/2010/04/18

4）给外部表加载数据

bin/hadoop fs -put /tmp/test.txt /tmp/test/2010/04/18/

 5）执行测试查询

　　[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 /tmp/test/2010/04

　　[hadoop@hadoopmaster hadoop-1.0.3]$ bin/hadoop fs -ls /tmp/test/2010/04

　　Found 1 items

drwxr-xr-x   - hadoop supergroup          0 2012-07-03 19:17 /tmp/test/2010/04/18