Wow, that's really awesome, Josh. Nice work. Can you let us know if/when it makes it in?
One modification you may want to consider in a future revision to protect yourself in case the SYSTEM.CATALOG schema changes down the road: Use the DatabaseMetaData APIs[1] instead of querying the SYSTEM.CATALOG table directly. You can access this through the Connection (connection.getMetaData()). Just a wild guess, but for the zookeeper exception you mentioned that can be ignored, is it maybe related to not setting the hbase.master.info.port to -1? Thanks, James [1] http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html On Wed, Jan 14, 2015 at 1:41 PM, Josh Mahonin <jmaho...@interset.com> wrote: > Hi all, > > As an FYI, I've got a pull request into Flyway (http://flywaydb.org/) for > Phoenix support: > https://github.com/flyway/flyway/pull/930 > > I don't know what everyone else is using for schema management, if anything > at all, but the preliminary support works well enough for Flyway's various > commands (migrate, clean, baseline, repair, etc.). > > A lot of the functionality is using direct queries against SYSTEM.CATALOG, > so it's entirely possible I'm doing something incorrectly, but it passes a > fairly extensive suite of tests. If anyone else wants to take a quick look > at the code to double check everything looks in order, that would be great. > > I've only tested against Phoenix 4.2.2, though it should be straight-forward > enough to support other versions as well. > > Josh