Reputation: 71
We're using Cassandra for data store, but want to migrate data out of Cassandra and into MySQL on a daily basis so that marketing/product users can query data independently using an SQL syntax.
Any advice here?
Upvotes: 7
Views: 2696
Reputation: 506
You can access your cassandra data via SQL using Hive, which is integrated into the DataStax Brisk distribution.
http://www.datastax.com/docs/0.8/brisk/about_hive
Upvotes: 5