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:
Tag: Sample data to create internal table in Hive
Hive Internal Tables Using CTAS
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)
Internal Tables in Hive – Part-3
This is a continuation of “Internal Tables in Hive” from the previous article. There is an option to decide where to place the data when
Internal Tables in Hive – Part-2
This is a continuation of “Internal Tables in Hive” from the previous article. There is an option to decide where to place the data when
Internal Tables in Hive – Part-1
As mentioned in the previous post, when the data is temporary or if you want Hive to control the life cycle of the table and
Big Data & SQL 