question i want to create visual report from hive result ? in Archives of Support Questions (Read Only)

i want to create visual report from hive result ?

heta_desai — Thu, 20 Apr 2017 14:06:19 GMT

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

Re: i want to create visual report from hive result ?

rajkumar_singh — Thu, 20 Apr 2017 14:14:28 GMT

@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)

Re: i want to create visual report from hive result ?

heta_desai — Thu, 20 Apr 2017 14:21:52 GMT

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.

Re: i want to create visual report from hive result ?

rajkumar_singh — Thu, 20 Apr 2017 15:36:00 GMT

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.