Hi Yogesh, If you have correctly set-up your metastore (in MySQL or the Derby default) it should work.
try HQL statements in the HWI like: show tables; describe <table_name>; describe extended <table_name>; Jasper 2012/7/18 <[email protected]> > Hi Jasper, > > I have just changed the path from /HADOOP/hive/lib/hive-hwi-0.8.1.war to > /lib/hive-hwi-0.8.1.war and it just worked :-) > > > ******************************************************************************************************* > <property> > <name>hive.hwi.war.file</name> > <value>/HADOOP/hive/lib/hive-hwi-0.8.1.war</value>* /* (Here is > the hive directory) */ > > *to * > > > * <value>/lib/hive-hwi-0.8.1.war</value> > <description>This is the WAR file with the jsp content for Hive > Web Interface</description> > </property> > > > ******************************************************************************************************* > > > Now I want to run queries like displaying Hive's table data, is it > possible to do it from Hive Web services. If so then how? > > Please suggest > > Regards > Yogesh Kumar Dhari > ------------------------------ > *From:* Jasper Knulst [[email protected]] > *Sent:* Wednesday, July 18, 2012 3:40 PM > *To:* [email protected] > *Subject:* Re: Hive Web Services > > Hi Yogesh, > > Can you tell us what you eventually had to do to get the HWI running ? > (seen your earlier mail topic where you had some trouble to get it going) > > Was it the relative path? > > Thanks > > Jasper > > 2012/7/18 <[email protected]> > >> Hi all, >> >> I have installed hadoop and hive and its working well through terminal, >> I have also started HWI (http://localhost:9999/hwi) >> >> Now I want to run queries like displaying Hive's table data, is it >> possible to do it from Hive Web services. If so then how? >> >> Please suggest >> >> Regards >> Yogesh Dhari >> >> >> *Please do not print this email unless it is absolutely necessary. ***** >> >> The information contained in this electronic message and any attachments >> to this message are intended for the exclusive use of the addressee(s) and >> may contain proprietary, confidential or privileged information. If you are >> not the intended recipient, you should not disseminate, distribute or copy >> this e-mail. Please notify the sender immediately and destroy all copies of >> this message and any attachments. >> >> WARNING: Computer viruses can be transmitted via email. The recipient >> should check this email and any attachments for the presence of viruses. >> The company accepts no liability for any damage caused by any virus >> transmitted by this email. >> >> www.wipro.com >> > > > > -- > > > * Please do not print this email unless it is absolutely necessary. **** > * > > The information contained in this electronic message and any attachments > to this message are intended for the exclusive use of the addressee(s) and > may contain proprietary, confidential or privileged information. If you are > not the intended recipient, you should not disseminate, distribute or copy > this e-mail. Please notify the sender immediately and destroy all copies of > this message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. > The company accepts no liability for any damage caused by any virus > transmitted by this email. > > www.wipro.com > --
