i want to create visual report from hive result ?

[#1]

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

[#2 · 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)

[#3]

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.

[#4]

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.