Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Generate Hive DDL


Copy link to this message
-
Generate Hive DDL
Folks,

I was wondering if any one is aware of a way to generate Hive DDL scripts using the existing metastore which in our case is in postgres. We have a few tables which have been historically created and figuring our creating ways to get the schema as DDL so that we can keep it in under version control.  We could replicate the entire metastore would we just want 4 tables out of the 100 we already have in place.

Thanks,
murtaza
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB