Create hive table with same schema without any data

[mahender bigdata <Ma...@outlook.com>]

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.

RE: Create hive table with same schema without any data

[Ryan Harris <Ry...@zionsbancorp.com>]

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableLike

-----Original Message-----
From: mahender bigdata [mailto:Mahender.BigData@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.