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 visualize hortonworks hive table data into d3.js

Solved Go to solution
Highlighted

how to visualize hortonworks hive table data into d3.js

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

Accepted Solutions

Re: how to visualize hortonworks hive table data into d3.js

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)

4 REPLIES 4

Re: how to visualize hortonworks hive table data into d3.js

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)

Re: how to visualize hortonworks hive table data into d3.js

@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

Re: how to visualize hortonworks hive table data into d3.js

New 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?

Re: how to visualize hortonworks hive table data into d3.js

Contributor

@Paul Boali just want d3 for ad hoc data visualization