phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Flyway DB Migrations
Date Thu, 15 Jan 2015 01:35:08 GMT
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 <jmahonin@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

Mime
View raw message