RE: Validation of Data after data migration from RDBMS to Cassandra
Surbhi, A general note, Cassandra tables are not normalized as in an RDBMS schema, so it’s not straight migration. Best practice is to design your queries and then design your Cassandra schema to support those queries. Patrick McFadin has a series on C* data modeling. http://docs.datastax.com/en/cassandra/2.1 Roger From: Surbhi Gupta [mailto:surbhi.gupt...@gmail.com] Sent: Thursday, August 06, 2015 11:31 AM To: user@cassandra.apache.org Subject: Validation of Data after data migration from RDBMS to Cassandra Hi, We have to migrate the data from Oracle/mysql to Cassandra. I wanted to understand, if we have any tool/utilitiy which can help in validation the data after the data migration to Cassandra. Thanks Surbhi
RE: Validation of Data after data migration from RDBMS to Cassandra
Surbhi Sorry I meant to send the CQL link http://docs.datastax.com/en/cql/3.1/cql/cql_intro_c.html Roger From: Huang, Roger [mailto:rohu...@visa.com] Sent: Thursday, August 06, 2015 11:39 AM To: user@cassandra.apache.org Subject: RE: Validation of Data after data migration from RDBMS to Cassandra Surbhi, A general note, Cassandra tables are not normalized as in an RDBMS schema, so it’s not straight migration. Best practice is to design your queries and then design your Cassandra schema to support those queries. Patrick McFadin has a series on C* data modeling. http://docs.datastax.com/en/cassandra/2.1 Roger From: Surbhi Gupta [mailto:surbhi.gupt...@gmail.com] Sent: Thursday, August 06, 2015 11:31 AM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Validation of Data after data migration from RDBMS to Cassandra Hi, We have to migrate the data from Oracle/mysql to Cassandra. I wanted to understand, if we have any tool/utilitiy which can help in validation the data after the data migration to Cassandra. Thanks Surbhi
Re: Validation of Data after data migration from RDBMS to Cassandra
We do not use a tool exactly. We use spark to assert all of our data is in tact, taking into account the changes that you have to make going from rdbms to nosql. On Thu, Aug 6, 2015 at 1:32 PM, Huang, Roger rohu...@visa.com wrote: Surbhi Sorry I meant to send the CQL link http://docs.datastax.com/en/cql/3.1/cql/cql_intro_c.html Roger *From:* Huang, Roger [mailto:rohu...@visa.com] *Sent:* Thursday, August 06, 2015 11:39 AM *To:* user@cassandra.apache.org *Subject:* RE: Validation of Data after data migration from RDBMS to Cassandra Surbhi, A general note, Cassandra tables are not normalized as in an RDBMS schema, so it’s not straight migration. Best practice is to design your queries and then design your Cassandra schema to support those queries. Patrick McFadin has a series on C* data modeling. http://docs.datastax.com/en/cassandra/2.1 Roger *From:* Surbhi Gupta [mailto:surbhi.gupt...@gmail.com surbhi.gupt...@gmail.com] *Sent:* Thursday, August 06, 2015 11:31 AM *To:* user@cassandra.apache.org *Subject:* Validation of Data after data migration from RDBMS to Cassandra Hi, We have to migrate the data from Oracle/mysql to Cassandra. I wanted to understand, if we have any tool/utilitiy which can help in validation the data after the data migration to Cassandra. Thanks Surbhi -- Jason Kushmaul | 517.899.7852 Engineering Manager