question Re: truncate partition external table in Archives of Support Questions (Read Only)

truncate partition external table

Bangalore — Fri, 28 Apr 2017 14:27:52 GMT

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

sgowda — Fri, 28 Apr 2017 15:08:41 GMT

See if below link helps !

Bangalore — Fri, 28 Apr 2017 20:46:37 GMT

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