https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableLike
-----Original Message----- From: mahender bigdata [mailto:mahender.bigd...@outlook.com] Sent: Thursday, December 10, 2015 11:09 AM To: user@hive.apache.org Subject: Create hive table with same schema without any data Hi, Is there any alternate way for creating hive table with same table schema. We are currently doing with create table t1 as select * from t2 where 1 =2 or create table t1 like t2; Is there any other way of creating table with same schema as one of the table. ====================================================================== THIS ELECTRONIC MESSAGE, INCLUDING ANY ACCOMPANYING DOCUMENTS, IS CONFIDENTIAL and may contain information that is privileged and exempt from disclosure under applicable law. If you are neither the intended recipient nor responsible for delivering the message to the intended recipient, please note that any dissemination, distribution, copying or the taking of any action in reliance upon the message is strictly prohibited. If you have received this communication in error, please notify the sender immediately. Thank you.