how to visualize hortonworks hive table data into d3.js

[#1]

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

[#2 · Accepted solution]

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 Hortonworks sandbox

Hive view:

https://community.hortonworks.com/content/kbentry/...

http://hortonworks.com/blog/improving-operations-w...

Zeppelin:

http://hortonworks.com/hadoop/zeppelin/

https://community.hortonworks.com/content/kbentry/...

However if you are interested in implementing it yourself, you can check some of the examples mentioned here:

https://groups.google.com/forum/#!topic/d3-js/aRKF...

https://github.com/dp1140a/HDP-Viz (screenshots available here)

[#3]

@sivasaravanakumar k

Found this easy example http://stackoverflow.com/questions/17716386/any-on...

Use Hive Query like

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;

and make as Json_tuple then you can easly use That json to D3js

[#4]

Could you clarify your question @sivasaravanakumar k - do you want to build an application using d3 or just use d3 for ad hoc data visualization?

[#5]

@Paul Boali just want d3 for ad hoc data visualization