hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ryan Harris <Ryan.Har...@zionsbancorp.com>
Subject RE: Create hive table with same schema without any data
Date Thu, 10 Dec 2015 18:12:58 GMT
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.
Mime
View raw message