Have you looked at https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport? Why does this not suit your use case?
Regards, Johannes Sent from my iPhone > On Feb 23, 2018, at 3:40 PM, Alexander Kolbasov <ak...@cloudera.com> wrote: > > Would it be useful to have a tool that can save database(s), table(s) and > partition(s) metadata in a file and then import this file in another > metastore? These files can be stored together with data files or elsewhere. > > This would allow for targeted exchange of metadata between multiple HMS > services. > > - Alex