Can I change a table from internal to external in hive?

user_1492174 0
Viewed 43600

I created a table in hive as a managed table, but it was supposed to be external, is it possible to change the table type of the table without losing the data?

hive external types
3 Answers

alter table <table_name> SET TBLPROPERTIES('EXTERNAL'='TRUE')

Note: It work only if it is non transactional internal/managed table.

user_43047320
Related