search

patka / cassandra-migration

Schema migration library for Cassandra
MIT License
152 stars 47 forks source link

Support for Amazon Keyspaces (AWS MCS) #51

Open mihai-vasilache opened 4 years ago

mihai-vasilache commented 4 years ago

Amazon managed Cassandra service execute DDL statements asynchronously. Meaning that we receive errors like keyspace or table (schema_migration) does not exist because it takes some time to create them asynchronously. https://docs.aws.amazon.com/keyspaces/latest/devguide/functional-differences.html#functional-differences.table-keyspace-management There are some queries that can be performed to see when the tables are created. Do you have any idea how support can be added to this async execution in this project? I think that it is too complicated to parse the migration cql files and recognize create table statements, extract table name and then query for table creation finalization.

patka commented 4 years ago

Hi,

sorry for the delay. That is what happens when the read the mail and don't answer immediately.

I have not yet spend any time on this but as AWS is most likely an important use case I will have a look at this. I could imagine dealing with this by using a different way to execute the statements as a strategy for that was already requested in a different place. Thanks for bringing this up.

mihai-vasilache commented 3 years ago

Hi! Sorry for the long delay. I had some time those days and I've created a pull request with support for aws mcs. pull request 56