Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

New Contributor

@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. :P

Thanks,

Raghvendra Singh

1 ACCEPTED SOLUTION

Accepted Solutions

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

@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.

1 REPLY 1

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

@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.

Don't have an account?
Coming from Hortonworks? Activate your account here