Data visualisation tools availble on hive hadoop

Question

Please suggest some visualisation tools which can work on Hive-Hadoop.

The only thing is, it should accept Hive .

Answer 1

It depends what type of data analysis and visualization you have in mind.

If you intend to use a proprietary tool, then Tableau is one of among many other options.

If you prefer tools that are open source (free and multi-platform), then you should consider using:

• HUE Beeswax
• HBase Pig
• Google Chart
• ColorBrewer
• R
• Qt/QML
• Octave
• OpenGL

Hive will not block you from using any of those tools for data visualization, as long as you know how to manipulate your data and how to work with the respective toll for analysis/visualization of your data.

Answer 2

Check out the nascent Zeppelin project ( http://zeppelin-project.org )

Answer 3

You can use elasticsearch's kibana(I'd prefer v3). That is;

1. Create an external table in Hive, which uses elasticsearch. Just as exaplained in: https://www.elastic.co/guide/en/elasticsearch/hadoop/current/hive.html
2. Insert your data into this external table.
3. Point your kibana to your elasticsearch.
4. In kibana select the index/type and create your own dashboard.