Apache Zeppelin as a Web Querying Interface for Cassandra

Hi!

An important thing that you are missing when starting to use Cassandra is a decent web tool

for executing CQL queries, and browsing the results.

Googling for a “Cassandra web ui” results in RazorSql, and some other not so promising engines, where most of them are not a web UI at all.

As you can tell, by the post’s title, Apache Zeppelin turned out to be a great solution for our need.

It has a built in Cassandra Interpreter , which only requires basic connection properties.

Here is a video explaining all about Zeppelin and Cassandra

We did had one issue with installing Zeppelin on our VPC, and trying to access it via Nginx and AWS load balancer:

  • Apache Zeppelin is using a web socket for a client-server connectivity.
  • It requires special configuration on Nginx: how to configure Apache Zeppelin on Nginx
  • It enforced us to use Application Load Balancer, instead of Classic Load Balancer, which doesn’t support web sockets out of the box.

As a result, we no longer have to ssh Cassandra nodes, in order to execute CQL queries.

I hope that everyone who is looking for a CQL web ui, would find his answer here (or a better answer somewhere else :) ).

稿源:Hadoop.distcp (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » Apache Zeppelin as a Web Querying Interface for Cassandra

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录