Internal tables using CTAS

Can We Create An External Table Using CTAS?

10th Dec 2020 SHAFI SHAIK

Can we create an external table using CTAS? The answer is NO. (Read till the end) As per the Hive’s documentation, CTAS has these restrictions:

Hive Internal Tables Using CTAS

10th Dec 2020 SHAFI SHAIK

In addition to previous implementations of the creation of internal tables (a.k.a. managed tables), another approach for creating internal tables is using the CTAS (create-table-as-select)