Support Questions

Find answers, ask questions, and share your expertise

i want to create visual report from hive result ?

Expert Contributor

Hello,

i am using hadoop on hdinsight. i want to process data in hive and then display the result in visual form like graph chart. how can i do this can anyone give suggetion.

can i create a webpage on that i can display the hive query result in graphical format ?

if yes, how it is possible ? how can i connect hive with webpage ?

thank you

1 ACCEPTED SOLUTION

@heta desai you can pull the query result from hive using hive-jdbc and plot using d3js (https://d3js.org/) or c3js (http://c3js.org/examples.html)

View solution in original post

3 REPLIES 3

@heta desai you can pull the query result from hive using hive-jdbc and plot using d3js (https://d3js.org/) or c3js (http://c3js.org/examples.html)

Expert Contributor

Thanks for the reply.

can you please give me the proper document for this.

do i need to store the hive result some where like in RDBMS and then i can plot ?

i am new to hadoop.

no need to store the result in RDBMS, these libraries are javascript library, you can pull the result using java jdbc program https://github.com/rajkrrsingh/HiveServer2JDBCSample, set in some variable and plot using these libraries.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.