question Re: how to visualize hortonworks hive table data into d3.js in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101790#M14414 <A rel="user" href="https://community.cloudera.com/users/838/hadoopsmi.html" nodeid="838">@sivasaravanakumar k</A><P>Found this easy example <A href="http://stackoverflow.com/questions/17716386/any-one-know-how-to-apache-hive-data-visualization-using-d3js">http://stackoverflow.com/questions/17716386/any-on...</A></P><P>Use Hive Query like</P><P>SELECT b.blogID, count(b.name) FROM comments a LATERAL VIEW json_tuple(a.value, 'blogID', 'name') b AS blogID, name group by b.blogID;</P><P>and make as Json_tuple then you can easly use That json to D3js</P> Thu, 07 Jan 2016 20:57:05 GMT nsabharwal 2016-01-07T20:57:05Z how to visualize hortonworks hive table data into d3.js https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101788#M14412 <P>i want visualize hive table data into d3.js ,i dont know how to connect d3.js and hive table , any one help me and also if u know any opensource visualzeation tools inform me</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1219-1.png" style="width: 1354px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/23735i2B423285F68A1CC7/image-size/medium?v=v2&amp;px=400" role="button" title="1219-1.png" alt="1219-1.png" /></span></P> Mon, 19 Aug 2019 12:18:54 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101788#M14412 hadoopsmi 2019-08-19T12:18:54Z Re: how to visualize hortonworks hive table data into d3.js https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101789#M14413 <P>If you are ok with existing JS based tools to visualize Hive data, you can check the Hive view and Zeppelin which use javascript libraries to visualize data in Hive. Both of these are available in <A href="http://hortonworks.com/products/hortonworks-sandbox/#install">Hortonworks sandbox</A></P><P>Hive view:</P><P><A href="https://community.hortonworks.com/content/kbentry/2947/new-visualization-feature-in-hive-view.html">https://community.hortonworks.com/content/kbentry/...</A></P><P><A href="http://hortonworks.com/blog/improving-operations-with-ambari-user-views/">http://hortonworks.com/blog/improving-operations-w...</A></P><P>Zeppelin:</P><P><A href="http://hortonworks.com/hadoop/zeppelin/">http://hortonworks.com/hadoop/zeppelin/</A></P><P><A href="https://community.hortonworks.com/content/kbentry/3029/apache-zeppelin-walk-through.html">https://community.hortonworks.com/content/kbentry/...</A></P><P>However if you are interested in implementing it yourself, you can check some of the examples mentioned here:</P><P><A href="https://groups.google.com/forum/#!topic/d3-js/aRKFtUaE5h4">https://groups.google.com/forum/#!topic/d3-js/aRKF...</A></P><P><A href="https://github.com/dp1140a/HDP-Viz">https://github.com/dp1140a/HDP-Viz</A> (screenshots available <A href="https://github.com/abajwa-hw/hdpviz">here</A>)</P> Thu, 07 Jan 2016 14:40:01 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101789#M14413 abajwa 2016-01-07T14:40:01Z Re: how to visualize hortonworks hive table data into d3.js https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101790#M14414 <A rel="user" href="https://community.cloudera.com/users/838/hadoopsmi.html" nodeid="838">@sivasaravanakumar k</A><P>Found this easy example <A href="http://stackoverflow.com/questions/17716386/any-one-know-how-to-apache-hive-data-visualization-using-d3js">http://stackoverflow.com/questions/17716386/any-on...</A></P><P>Use Hive Query like</P><P>SELECT b.blogID, count(b.name) FROM comments a LATERAL VIEW json_tuple(a.value, 'blogID', 'name') b AS blogID, name group by b.blogID;</P><P>and make as Json_tuple then you can easly use That json to D3js</P> Thu, 07 Jan 2016 20:57:05 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101790#M14414 nsabharwal 2016-01-07T20:57:05Z Re: how to visualize hortonworks hive table data into d3.js https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101791#M14415 <P>Could you clarify your question <A rel="user" href="https://community.cloudera.com/users/838/hadoopsmi.html" nodeid="838">@sivasaravanakumar k</A> - do you want to build an application using d3 or just use d3 for ad hoc data visualization?</P><P></P> Fri, 08 Jan 2016 06:26:07 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101791#M14415 paul_boal 2016-01-08T06:26:07Z Re: how to visualize hortonworks hive table data into d3.js https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101792#M14416 <P><A rel="user" href="https://community.cloudera.com/users/813/paulboal.html" nodeid="813">@Paul Boal</A>i just want d3 for ad hoc data visualization</P> Mon, 25 Jan 2016 15:49:38 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-visualize-hortonworks-hive-table-data-into-d3-js/m-p/101792#M14416 hadoopsmi 2016-01-25T15:49:38Z