How to pull data out of HAWQ for use in Live wed D3 dashboard?

[#1]

@allaboutbdata

@abawja

I have followed this post to setup single node HDP HAWQ cluster setup. Now that after all processing is done I have stored final results in HAWQ table that directly uses the HBASE table as External Table.

With the final results i want to create a live D3 dashboard using DC.js and leaflet. Therefore I am looking for a connector api to expose the HAWQ table data to D3 preferable in JSON format. I know I can write the connector using Ajax and Javascript, but I am hoping if someone knows a prebuilt method to do this. I am bit reluctant to reinvent the wheel. 😛

Thanks,

Raghvendra Singh

[#2 · Accepted solution]

@Raghvendra Singh

Tutorial: http://hortonworks.com/hadoop-tutorial/getting-started-with-pivotal-hawq-on-hortonworks-sandbox/

Look for section USING OTHER TOOLS TO WORK WITH HAWQ

Follow instructions on how to download ODBC/JDBC driver and how to use it.

If your data stored is JSON then you are set, otherwise you have to handle it before displaying to your d3js based dashboard. HAWQ is SQL-like database with advance ANSI compliance.