For an existing mysql database, I have a tool which dumps out the
create table statements for all tables, and checks them into SVN on a
daily basis, to keep the schema under version control. For various
reasons, this works better for my team than a change script model. We
have recently started using hive as a primary data store, and I would
like to apply a similar idea to the hive schema. Ideally, I would
like a command to directly dump the create table statements, but I can
also construct them out of several outputs if all the data is
available. In particular, I'm having a hard time finding the row
format and partition information.
I'm also interested in hearing what schema versioning techniques have
worked for anyone else.
Thanks in advance,