@Saumil Mayani If you want to get ddl of tables mysql -u hive -p -e " select concat( 'show create table ' , TBL_NAME,';') from TBLS" hive > file.sql
remove header in file.sql
hive -f /tmp/file.sql
Details [root@phdns02 ~]# Table names login to mysql use hive; select concat( 'show create table ' , TBL_NAME,';') from TBLS; or mysql -u hive -p -e " select concat( 'show create table ' , TBL_NAME,';') from TBLS" hive > file.sql You can add above output in shell and run this [root@phdns02 ~]# su - hive [hive@phdns02 ~]$ hive -f /tmp/h.ddl WARNING: Use "yarn jar" to launch YARN applications. Logging initialized using configuration in file:/etc/hive/2.3.4.0-3276/0/hive-log4j.properties OK CREATE TABLE `hadoop`( `name` string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 'hdfs://phdns01.cloud.hortonworks.com:8020/apps/hive/warehouse/hadoop' TBLPROPERTIES ( 'transient_lastDdlTime'='1448062564') Time taken: 2.045 seconds, Fetched: 12 row(s) OK CREATE TABLE `ns`( `name` string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 'hdfs://phdns01.cloud.hortonworks.com:8020/apps/hive/warehouse/ns' TBLPROPERTIES ( 'transient_lastDdlTime'='1448062211') Time taken: 0.067 seconds, Fetched: 12 row(s) [hive@phdns02 ~]$
... View more
