Is it hive database created in MySQL ?? On Tue, Oct 11, 2011 at 5:55 PM, Vikas Srivastava < vikas.srivast...@one97.net> wrote:
> that also i have dine.. i put msql connector in that lib > > On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain <ankitjainc...@gmail.com>wrote: > >> Hello Vikas, >> >> I think you have to put the mysql Driver in lib dir of hive. >> >> Thanks, >> Ankit >> >> On Tue, Oct 11, 2011 at 5:18 PM, Vikas Srivastava < >> vikas.srivast...@one97.net> wrote: >> >>> hey thanks for replay but already have at that place.. >>> >>> 2011/10/11 Harold(陳春宏) <harold.c...@sunplus-technology.com> >>> >>>> >>>> >>>> You have to add jar file like this >>>> add jar ../hive-0.6.0/lib/hive_contrib.jar; >>>> >>>> >>>> >>>> Best Regard >>>> Mail: harold.c...@sunplus-technology.com >>>> MSN: chen0...@hotmail.com >>>> SKYPE: chen0727 >>>> Mobil: 886-937545215 >>>> Tel: 886-2-8798-2988 #222 >>>> Fax:886-2-8751-5499 >>>> >>>> -----Original Message----- >>>> From: vikas srivastava [mailto:vikas.srivast...@one97.net] >>>> Sent: Tuesday, October 11, 2011 3:29 PM >>>> To: user@hive.apache.org >>>> Subject: problem in hive >>>> >>>> Hi All, >>>> >>>> I facing a problem like I have installed hive on a new server and >>>> provide >>>> the connectivity with the namenode, >>>> >>>> Create a user in mysql and give the proper privileges to that user, >>>> >>>> Put that user in hive-site.xml and now when I fired a query like >>>> >>>> Show tables; >>>> Not showing any table >>>> >>>> when I fired >>>> Desc table or select table is throwing an error >>>> >>>> hive> desc aircel_obd; >>>> FAILED: Execution Error, return code 1 from >>>> org.apache.hadoop.hive.ql.exec.DDLTask >>>> >>>> >>>> The hive.log are :- >>>> >>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.resources" but it cannot be resolved. >>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.resources" but it cannot be resolved. >>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.runtime" but it cannot be resolved. >>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.runtime" but it cannot be resolved. >>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.text" but it cannot be resolved. >>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.text" but it cannot be resolved. >>>> 2011-10-11 12:25:35,031 ERROR ql.Driver >>>> (SessionState.java:printError(365)) >>>> - FAILED: Execution Error, return code 1 from >>>> org.apache.hadoop.hive.ql.exec.DDLTask >>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.resources" but it cannot be resolved. >>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.resources" but it cannot be resolved. >>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.runtime" but it cannot be resolved. >>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.core.runtime" but it cannot be resolved. >>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.text" but it cannot be resolved. >>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin >>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires >>>> "org.eclipse.text" but it cannot be resolved. >>>> 2011-10-11 12:45:21,053 ERROR ql.Driver >>>> (SessionState.java:printError(365)) >>>> - FAILED: Execution Error, return code 1 from >>>> org.apache.hadoop.hive.ql.exec.DDLTask >>>> >>>> Please help I m stuck here.... >>>> >>>> >>>> With Regards >>>> Vikas Srivastava >>>> >>>> DWH & Analytics Team >>>> M: +91 9560885900 >>>> P: + 91 120 4770102 >>>> Email: vikas.srivast...@one97.net >>>> W: www.one97world.com >>>> >>>> One97 | Let's get talking ! >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> With Regards >>> Vikas Srivastava >>> >>> DWH & Analytics Team >>> Mob:+91 9560885900 >>> >>> One97 | Let's get talking ! >>> >>> >> > > > -- > With Regards > Vikas Srivastava > > DWH & Analytics Team > Mob:+91 9560885900 > One97 | Let's get talking ! > >