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 fetch hive data from html/jquery web pages?

Solved Go to solution
Highlighted

how to fetch hive data from html/jquery web pages?

Hi,

I'm working on a project, in that i have to fetch data from hive table to my web pages which was developed in html & jquery.

Can u please suggest me any idea to do so..or shall we use obdc connectivity to retrieve those hive records.

Thanks in advance.

Regards,

Priya

1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to fetch hive data from html/jquery web pages?

Thats not possible, you need some kind of middleware between your frontend (html/jquery) and your data service (hive). So you basically have to create a backend, e.g. with Spring or Play, which is taking requests from your frontend, querying hive and sending the result back to your frontend as soon as the Hive query was executed.

You can also use ODBC.

Take a look at this http://hortonworks.com/hadoop-tutorial/how-use-excel-2013-to-analyze-hadoop-data/

Is the website (html/jquery) only used to display data for a single user or will this be something like, one of many users visits a private page and individual data is pulled from hive and displayed on the frontend.

3 REPLIES 3

Re: how to fetch hive data from html/jquery web pages?

Mentor

@priya dharshini please see this.

Re: how to fetch hive data from html/jquery web pages?

Thats not possible, you need some kind of middleware between your frontend (html/jquery) and your data service (hive). So you basically have to create a backend, e.g. with Spring or Play, which is taking requests from your frontend, querying hive and sending the result back to your frontend as soon as the Hive query was executed.

You can also use ODBC.

Take a look at this http://hortonworks.com/hadoop-tutorial/how-use-excel-2013-to-analyze-hadoop-data/

Is the website (html/jquery) only used to display data for a single user or will this be something like, one of many users visits a private page and individual data is pulled from hive and displayed on the frontend.

Re: how to fetch hive data from html/jquery web pages?

Mentor

@priya dharshini are you still having issues with this? Can you accept best answer or provide your workaround?

Don't have an account?
Coming from Hortonworks? Activate your account here