How to create an empty copy of a table in hive

Question

I have a table with lots of columns. I don't want to write something like

CREATE TABLE IF NOT EXISTS 
table1( 
col1 int, 
col2 String,
etc....)

Is there a fast way to create a table with the same structure, but without any data?

score 12 · Accepted Answer · answered Jan 17 '17 at 12:15

12

Try this:

CREATE TABLE some_db.T1 LIKE some_db.T2

answered Jan 17 '17 at 12:15

leftjoin

3

Additionally, you can just show the command that created the table using `SHOW CREATE TABLE `
– Andrea Jan 17 '17 at 13:01
additionally， this comand will also create same partition table like the sourse table. – Song Jul 17 '23 at 10:32

1 Answers1