Support Questions
Find answers, ask questions, and share your expertise

Visualizing HBase Data with standard BI or Portal Front-end tools

Visualizing HBase Data with standard BI or Portal Front-end tools

Explorer

If I have loaded all my data into HBase succesfully. What would be a recommended way of visualizing that data using standard BI or Portal tools ? So e.g. using something like Tableau, QlikView or Tibco Spotfire. Where users can just drill and click quickly through the data. How can I connect those tools to HBase to allow having a nice looking standard GUI to my HBase data ? Are there drivers available (ODBC, JDBC etc.) ? Can I connect with those tools to e.g. the standard HBase REST interface ?

any advice really appreciated.

4 REPLIES 4
Highlighted

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

Hi @Gerald Both many of the tools that you've mentioned don't (yet?) support HBase directly, you could always use something like Apache Phoenix, to allow sql querying of your nosql store but that still doesn't get you directly to the visualisation as the SQL semantics supported are far less than something like Hive etc.

I've seen a few people use a product called Keylines

http://cambridge-intelligence.com/keylines/visualizing-nosql-database/

I have no affiliation to the folks above, but I notice that there's a free trial available.

Let us know how you get on!

Highlighted

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

Mentor

one option is to create a hive view on top of hbase table and connect that to Tableau. https://community.hortonworks.com/content/kbentry/14806/working-with-hbase-and-hive-wip.html

Highlighted

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

Hive over Hbase can be a good solution if your hbase tables has a fixed schema. But if you have a variable schema, give a look at http://www.simba.com/drivers/hbase-odbc-jdbc/.

The simba driver is commercial one and i guess a trial version is available and worth giving a try.

P.S. I am no affiliation to simba.

Highlighted

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

Explorer

thank you all. Very interesting. I would hope that some of the commercial BI Front-end, Portal Providers close this gap so that we can directly visualize on-top of HBase. Or e.g. the HBase community closes that gap. There is definitely a need in my view to use standard front-end tools on the data you have in HBase.

What would be the "standard" way to visualize that data ? Write a custom front-end which connects to the HBase REST API or similar ?