How can we help you today? How can we help you today?

Using flyway-database-cassandra with AWS Keyspaces

Hello,

I've got a system where we've been migrating from using Cassandra to using AWS Keyspaces. In theory they're very similar, but there are a few differences, since AWS Keyspaces adds some partitioning to allow it to scale.

I've been able to get my code to authenticate with Keyspaces, but when it does what I believe is an initial aliveness check it errors with this: 

com.datastax.oss.driver.api.core.servererrors.InvalidQueryException: countRows is not yet supported.

This isn't really a surprise, in that keyspaces limits the cql that it supports, but since this is an aliveness check it seems like there should be a different query that would be supported by both Cassandra and Keyspaces.

Has anyone managed to get flyway to work with keyspaces, and if so, what are the tricks to do so? If not, how hard is it to change that aliveness check to something that is supported by keyspaces?

Ian_N
0

Comments

2 comments

Sort by
  • Peter Laws
    Official comment

    Hello Ian,

    Based on the difference it seems that AWS Keyspaces would need a dedicated implementation. That's not something Redgate is presently looking at, but the community might pick it up, it's worth sharing your interest there, other users may also share your interest.

    Peter Laws
  • Felix Chandler

    Well Explained.

    Felix Chandler
    0

Add comment

Please sign in to leave a comment.