CODEWITHSUNDEEP
apache-sparkcassandravisualization
Nakeuh
Nakeuh

Reputation: 1909

Time Series Visualization from Cassandra

I have a Cassandra Database and a Spark cluster that will get his inputs from Cassandra to do some processing.

In my Cassandra database, I have some table that are time series. I am looking for a way to visualize those time series easily without multiplying databases.

Grafana is a great tool for that, but infortunately, it seems like there is no way to plug it to Cassandra.

So, for now I am using Zeppelin notebooks using my Cassandra/Spark cluster, but the available features to display time series aren't as good as those from Grafana.

I also cannot replace my Cassandra by InfluxDB, because my Cassandra is not used only for time series storing.

Upvotes: 1

Views: 958

Answers (3)

Hades Architect
Hades Architect

Reputation: 153

A bit too late but there is a direct integration now, Cassandra datasource for Grafana

https://github.com/HadesArchitect/GrafanaCassandraDatasource

Upvotes: 2

Lakshman Battini
Lakshman Battini

Reputation: 1912

Unfortunately there is no direct plugin for Cassandra as a datasource for Grafana. Below are the different possible ways you can achieve Cassandra to Grafana integration.

  1. There is a pull request for Cassandra as a datasource https://github.com/grafana/grafana/pull/9774, this is not merged to Grafana master branch though. you could run a fork of Grafana with this PR and use the plugin.

  2. You can use KairosDB on top of Cassandra (We can configure KairosDB to use Cassandra as a Datastore, so no multiple databases:) and use KairosDB plugin. but this approach has some drawbacks:

    • we need to map the Cassandra schema to KairosDB schema, KairosDB schema is metrics based schema.
    • Though KairosDB uses cassandra as a Datastore, it will store the data in different schema and table, so data is duplicated.
    • If your app is writing data to Cassandra directly, you need to write simple client to pull the latest data from cassandra and push to KairosDB

  3. You can implement the SimpleJSON plugin for Grafana (https://github.com/grafana/simple-json-datasource). There are lots examples available for SimpleJSON implementation, write one for Cassandra and opensource :)

  4. You can push the data ElasticSearch and use it as a Datasource. ES is supported as a Datasource for all major visualization tools.

Upvotes: 4

Mehul Gupta
Mehul Gupta

Reputation: 438

I would suggest to use Banana Visualization, but for this Solr should be enabled on Timeseries Table. Banana is a forked version of KIBANA. Also has powerful dashboard configuration capabilities.

https://github.com/lucidworks/banana

Upvotes: 1

Related Questions