hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhavesh Shah <bhavesh25s...@gmail.com>
Subject Re: Hive partition problem
Date Thu, 31 May 2012 07:26:24 GMT
Sorry for previous reply. Actually you had try that one, I didn't saw that.
Really Sorry.

On Thu, May 31, 2012 at 12:53 PM, Bhavesh Shah <bhavesh25shah@gmail.com>wrote:

> Hello wd,
> Try this one... I am not sure about this
> ALTER TABLE t1 DROP PARTITION(dt = '111')
>
>
> --
> Regards,
> Bhavesh Shah
>
>
> On Thu, May 31, 2012 at 12:49 PM, wd <wd@wdicc.com> wrote:
>
>> hi,
>>
>> We setup a new hive 0.9 client, Found some sql did not work, for example
>>
>> hive> create table t1(a int) partitioned by ( dt int );
>> OK
>> Time taken: 0.097 seconds
>> hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
>> Copying data from file:/tmp/t
>> Copying file: file:/tmp/t
>> Loading data to table default.t1 partition (dt=111)
>> OK
>> Time taken: 0.375 seconds
>> hive> show partitions t1;
>> OK
>> dt=111
>> Time taken: 0.108 seconds
>> hive> alter table t1 drop partition ( dt=111 );
>> FAILED: Error in semantic analysis: Partition not found dt = 111
>> hive> alter table t1 drop partition ( dt='111' );
>> FAILED: Error in semantic analysis: Partition not found dt = '111'
>>
>>
>> So, how to delete the partition?
>>
>
>
>
>
>


-- 
Regards,
Bhavesh Shah

Mime
View raw message