How can I visualize hive data?

Question

I need a way to visualize data present in hive. I am running a custom multi node hadoop cluster with two slaves(datanode) and a master(namenode) on centOS. I already tried tableau but it is only compatible with packaged clusters like cloudera,hortonworks,etc. but not a custom cluster like mine.

Any help will be appreciated.

Thanks.

Answer 1

Please see: Data visualisation tools availble on hive hadoop

CMD line: Beeline Tools: Teradata SQL assistant, Squirrel SQL...

UI: Ambari Views, Zeppelin, Lumify...

I need to test your comment about Tableau only working with HDP or Cloudera...

Answer 2

You can visualize the output of hive with Zeppelin Which is an open source Big data visualization platform by Apache foundation. You can deploy zeppelin on your name node and you can run hive queries through zeppelin.

You can refer to this blog for detailed information on how to install and integrate hive with zeppelin

Answer 3

Hue

Hue is an open source Web interface for analyzing data with any Apache Hadoop.

Answer 4

Take a look on Hue and zeppelin - they can be simply configured for custom cluster.