Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

how to visualize hortonworks hive table data into d3.js

avatar
Expert Contributor

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

1219-1.png

1 ACCEPTED SOLUTION

avatar

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)

View solution in original post

4 REPLIES 4

avatar

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)

avatar
Master Mentor
@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

avatar
Contributor

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?

avatar
Expert Contributor

@Paul Boali just want d3 for ad hoc data visualization