truncate partition external table

[#1]

Hi All,

Can we truncate partition external table ?

Sharing an example where i faced the issue .

hive> truncate table abc.Stage_xact_personall_region_of_Sale partition (region_code='TYES');

FAILED: SemanticException [Error 10146]: Cannot truncate non-managed table abc.Stage_xact_personall_region_of_Sale .

Help will be much appreciated ASAP .

-Thanks

Satish

[#2 · Accepted solution]

@Satish Anjaneyappa

See if below link helps !

https://community.hortonworks.com/questions/79661/how-to-deletedrop-a-partition-of-an-external-table...

[#3]

Thanks a lot ..

It works

Consolidated answer

ALTER TABLE abc.Stage_xact_personall_region_of_Sale DROP PARTITION (region_code='TYES');

Then do an overwrite on it

insert overwrite table abc.Stage_xact_personall_region_of_Sale partition(region_code) select * from xyz.Region_Sale where region_code='TYES';

-Thanks

Satish