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
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
>