Best practice for cloning a partitioned hive table

Create schema on target cluster We can use show create table to get the create table sql of the table we would like to clone. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 > show create table mycart; CREATE TABLE `mycart`( `id` string, `gd_id` int, `create_day_id` int, `remove_day_id` int, `data_date` string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' STORED AS INPUTFORMAT 'org.