If a table is partitioned, we should only allow insertion/loading data in a partition - not the table. So, load data local inpath \"/Users/char/Documents/workspace/Hive-Clean/data/files/kv1.txt\" into table srcpart ; should fail.
I think there was already a jira for that - let me check and otherwise file one. Thanks, -namit On 7/9/09 6:13 AM, "He Yongqiang" <[email protected]> wrote: Hi all, The situation: create table srcpart(key string, value string) partitioned by (ds string, hr int); load data local inpath \"/Users/char/Documents/workspace/Hive-Clean/data/files/kv1.txt\" overwrite into table srcpart PARTITION (ds='2008-04-08', hr=11); load data local inpath \"/Users/char/Documents/workspace/Hive-Clean/data/files/kv1.txt\" into table srcpart ; And the command 'select * from srcpart' only access the partition data? And the data outside any partition is left untouched? Yongqiang
