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

types hive external
George TeVelde picture George TeVelde · Aug 7, 2012 · Viewed 29.1k times · Source

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?

Answer

George TeVelde picture George TeVelde · Aug 9, 2012 
ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE')

Note: EXTERNAL and TRUE need to caps or it will not work

Related questions

How to determine a Python variable's type?

How do I see the type of a variable whether it is unsigned 32 bit, signed 16 bit, etc.? How do I view it?

Read More
Change column type in pandas

I want to convert a table, represented as a list of lists, into a Pandas DataFrame. As an extremely simplified example: a = [['a', '1.2', '4.2'], ['b', '70', '0.03'], ['x', '5', '0']] df = pd.DataFrame(…

Read More
Determine the type of an object?

Is there a simple way to determine if a variable is a list, dictionary, or something else? I am getting an object back that may be either type and I need to be able to tell the difference.

Read More