Created 01-20-2016 06:19 AM
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
Created 01-20-2016 06:50 PM
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.
Created 01-20-2016 02:02 PM
@priya dharshini please see this.
Created 01-20-2016 06:50 PM
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.
Created 02-03-2016 01:40 AM
@priya dharshini are you still having issues with this? Can you accept best answer or provide your workaround?