We use Cassandra for data storage, but we want to transfer data from Cassandra to MySQL daily so that marketing / product users can query for data using SQL syntax.
Any advice here?
You can access cassandra data through SQL using Hive, which is integrated into the DataStax Brisk distribution.
http://www.datastax.com/docs/0.8/brisk/about_hive
I made this Java daemon using the Hector library for Cassandra mysql2cass .
https://github.com/luismartingil/mysql2cass
http://www.luismartingil.com/2012/07/20/152/
This is open source.
Source: https://habr.com/ru/post/888818/More articles:How can I remove selected data from the grid when a button is clicked? - c #Group assignment when adding a user to django-admin - djangoDjango users and groups - show admin group membership? - djangoHow can I send a comment by email? - emailSMTP server requires secure connection, or client failed authentication - asp.netMatching patterns of non-specialized types - dependent-typeGet an AS3 instance method reference from a class object - functionHow to verify an X509 certificate without importing a root certificate? - .net.htaccess in the root and subfolder, each of which is redirected to its own index.php - .htaccessWhat is the scope of unique_ptr returned by the function? - c ++All Articles