Create Table As Select (CTAS) in Hive

Create Table As Select (CTAS) in Hive

command: create table <tablename> as select * from <source_table>;

This command will create new table with same structure as source_table along with its data.

Refer below image