hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: ManagedTablePartition
Date Sat, 31 May 2014 21:01:22 GMT
Answers:
Yes.
Yes.

create table x. ....;
alter table x add partition (...) location '/wherever/your/want'

^ data dropped on delete.

create EXTERNAL table x. ....;
alter table x add partition (...) location '/wherever/your/want'

^ data NOT dropped on delete.




On Fri, May 30, 2014 at 11:45 PM, Ashish Garg <gargcreation1992@gmail.com>
wrote:

> Hello all,
> Can we create the partitioned table in managed table and can we specify
> the location other than default warehouse directory? If yes, then what is
> the benefit of external table. Is it just dropping the external table will
> not delete the entire data that is it will only delete the metadata. Is
> this the only benefit?
> Thanks and Regards,
> Ashish Garg
>

Mime
View raw message