RE: Create hive table with same schema without any data

2015-12-10 Thread Ryan Harris
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

Create hive table with same schema without any data

2015-12-10 Thread mahender bigdata
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.