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) statement. One should be aware that until the query results are populated, the table will not be seen by other users since CTAS is atomic. In other words, other users will either see a table containing the full results of the query or will not see a table at all.

Below is an example to create a managed (internal) table using CTAS.

CREATE TABLE empinfo2 
AS
SELECT * FROM empinfo;

Please note that there is a limitation to create external tables using CTAS.
You can only create internal (managed) tables using CTAS statement.

Now check what table the above statement created.

DESC EXTENDED empinfo2;