Connect to Cassandra
28 November, 2012
I am trying to see if Yellowfin can connect to a Cassandra data source. I know that it can connect to a Hive, but wanted to make sure. Would you just use the columnar database option when building the connection?
I couldn't find a definitive answer online.
I couldn't find a definitive answer online.
Hi Christopher,
we actually haven't tried connecting to Cassandra yet and don't know anyone who has. I see that it has a JDBC driver, therefore we can say Yellowfin can connect to it, however, whether or not Yellowfin can construct a query that can be understand by Cassandra can only be known through trial. When I get a moment I'll give it try and let you know what I find, in the meantime if you get around to giving it a try before me, then please tell us your results.
Regards,
David
we actually haven't tried connecting to Cassandra yet and don't know anyone who has. I see that it has a JDBC driver, therefore we can say Yellowfin can connect to it, however, whether or not Yellowfin can construct a query that can be understand by Cassandra can only be known through trial. When I get a moment I'll give it try and let you know what I find, in the meantime if you get around to giving it a try before me, then please tell us your results.
Regards,
David
Hello,
Cassandra is a document database, meaning that it has unstructured data, which cannot be expressed as tables, or columns and rows like a standard database.
However, JDBC drivers still exist for some document databases. However these drivers will usually not support a standard of SQL that is compatible with what Yellowfin generates.
You may find one that does.
We do have a partner that has created connections to Cassandra via a custom JDBC driver. But this involves some customization to work with a particular schema. Please contact us if you'd like to get in touch with our partner.
Alternatively you can run an ETL job to dump data from Cassandra into a relational source on a scheduled basis, so that Yellowfin can report off it.
Thanks,
Peter
Cassandra is a document database, meaning that it has unstructured data, which cannot be expressed as tables, or columns and rows like a standard database.
However, JDBC drivers still exist for some document databases. However these drivers will usually not support a standard of SQL that is compatible with what Yellowfin generates.
You may find one that does.
We do have a partner that has created connections to Cassandra via a custom JDBC driver. But this involves some customization to work with a particular schema. Please contact us if you'd like to get in touch with our partner.
Alternatively you can run an ETL job to dump data from Cassandra into a relational source on a scheduled basis, so that Yellowfin can report off it.
Thanks,
Peter
Cassandra is not a document store unlike MangoDB. It is a distributed key-value store with much richer data model more popularly known as BigTable. The key constructs are "KeySpace, ColumnFamily, Column, Name and Values". It supports a query language CQL which is similar to SQL (a very small subset actually). But I am not sure if YellowFin has any reported integration with Cassandra.
Best
Avinash
Best
Avinash