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 !
