https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-pull-data-out-of-HAWQ-for-use-in-Live-wed-D3/m-p/114922#M30470 <P>@allaboutbdata</P><P>@abawja</P><P>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. </P><P>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. <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P><P>Thanks,</P><P>Raghvendra Singh</P> Fri, 16 Sep 2022 10:23:03 GMT raghvendra_sing 2022-09-16T10:23:03Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-pull-data-out-of-HAWQ-for-use-in-Live-wed-D3/m-p/114922#M30470 <P>@allaboutbdata</P><P>@abawja</P><P>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. </P><P>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. <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P><P>Thanks,</P><P>Raghvendra Singh</P> Fri, 16 Sep 2022 10:23:03 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-pull-data-out-of-HAWQ-for-use-in-Live-wed-D3/m-p/114922#M30470 raghvendra_sing 2022-09-16T10:23:03Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-pull-data-out-of-HAWQ-for-use-in-Live-wed-D3/m-p/114923#M30471 <P>@<A href="https://community.hortonworks.com/users/10839/raghvendrasingh.html">Raghvendra Singh</A></P><P>Tutorial: <A href="http://hortonworks.com/hadoop-tutorial/getting-started-with-pivotal-hawq-on-hortonworks-sandbox/" target="_blank">http://hortonworks.com/hadoop-tutorial/getting-started-with-pivotal-hawq-on-hortonworks-sandbox/</A></P><P>Look for section USING OTHER TOOLS TO WORK WITH HAWQ</P><P>Follow instructions on how to download ODBC/JDBC driver and how to use it.</P><P>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. </P> Tue, 27 Dec 2016 06:01:44 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-pull-data-out-of-HAWQ-for-use-in-Live-wed-D3/m-p/114923#M30471 cstanca 2016-12-27T06:01:44Z