Hi Namit,
I found the jira issue https://issues.apache.org/jira/browse/HIVE-527.
On 09-7-9 下午10:17, "Namit Jain" <[email protected]> wrote:
> 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
>
