Thanks Shashwat. I added that and it works. Now my program is running. I have created a JAR of it and tried to execute but again some errors are there while executing JAR only. Error as:
hadoop@ubuntu:~$ java -jar PES.jar SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:rsrc:slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:rsrc:slf4j-log4j12-1.6.1_2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. Exception in thread "main" java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58) Caused by: java.lang.IncompatibleClassChangeError: class com.facebook.fb303.FacebookService$Client has interface org.apache.thrift.TServiceClient as super class at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:93) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at PracticeExecutiveSummary.dropAllTables(PracticeExecutiveSummary.java:1320) at PracticeExecutiveSummary.main(PracticeExecutiveSummary.java:43) ... 5 more hadoop@ubuntu:~$ On Fri, May 11, 2012 at 11:40 AM, shashwat shriparv < dwivedishash...@gmail.com> wrote: > have you added *hive_hbase-handler.jar* to your project > > > On Fri, May 11, 2012 at 10:13 AM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > >> I perform all this above steps and whenI tried to run in eclipse I got >> error. >> The error as: >> >> *java.sql.SQLException: Method not supported >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:210) >> at TestSP.quarterTable(TestSP.java:598) >> at TestSP.main(TestSP.java:73) >> * >> >> On Thu, May 10, 2012 at 8:49 PM, shashwat shriparv < >> dwivedishash...@gmail.com> wrote: >> >>> Addition to my last reply ,,, come out from hive cli.. when you are >>> going to run your jdbc code. and dont try to connect using cli when your >>> jdbc code is running.... >>> >>> Cheers >>> Shashwat. >>> >>> >>> On Thu, May 10, 2012 at 8:39 PM, shashwat shriparv < >>> dwivedishash...@gmail.com> wrote: >>> >>>> For this error : " >>>> *java.sql.SQLException: Query returned non-zero code: 9, cause: >>>> FAILED: Execution Error, return code 2 from >>>> org.apache.hadoop.hive.ql.exec.MapRedTask >>>> at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuer* " >>>> >>>> Go to this link : >>>> http://docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/UsingEMR_Hive.html >>>> >>>> >>>> and add >>>> >>>> hadoop-0.20-core.jar >>>> hive/lib/hive-exec-0.7.1.jar >>>> hive/lib/hive-jdbc-0.7.1.jar >>>> hive/lib/hive-metastore-0.7.1.jar >>>> hive/lib/hive-service-0.7.1.jar >>>> hive/lib/libfb303.jar >>>> lib/commons-logging-1.0.4.jar >>>> slf4j-api-1.6.1.jar >>>> slf4j-log4j12-1.6.1.jar >>>> >>>> >>>> to the class path of your project , add this jars from the lib of >>>> hadoop and hive, and try the code. and also add the path of hadoop, hive, >>>> and hbase(if your are using) lib folder path to the project class path, >>>> like you have added the jars. >>>> >>>> and for the second error you got >>>> >>>> type >>>> >>>> netstat -nl | grep 10000 >>>> >>>> if it shows something means hive server is already running. the second >>>> error comes only when the port you are specifying is already acquired by >>>> some other proces, by default server port is 10000 so very with the above >>>> netstat command which i said. >>>> >>>> Note : suppose you have connected using code exit from ... bin/hive >>>> of if you are connected through bin/hive > then code will not connect >>>> because i think (not sure) only one client can connect to the hive server. >>>> >>>> do above steps hopefully will solve your problem. >>>> >>>> >>>> Regards >>>> >>>> ∞ >>>> Shashwat Shriparv >>>> >>>> >>>> >>>> On Thu, May 10, 2012 at 7:03 PM, Mark Grover <mgro...@oanda.com> wrote: >>>> >>>>> Hi Bhavesh, >>>>> You will have to check your Jobtracker logs for more details. If you >>>>> are using AWS, they should be in your S3 logs directory under >>>>> <job_flow_id>/daemons/<master_node_id>/hadoop-hadoop-jobtracker...log >>>>> >>>>> Mark >>>>> >>>>> Mark Grover, Business Intelligence Analyst >>>>> OANDA Corporation >>>>> >>>>> www: oanda.com www: fxtrade.com >>>>> >>>>> ----- Original Message ----- >>>>> From: "Bhavesh Shah" <bhavesh25s...@gmail.com> >>>>> To: user@hive.apache.org, d...@hive.apache.org >>>>> Sent: Thursday, May 10, 2012 6:27:28 AM >>>>> Subject: hive failed execution error return code 2 from >>>>> org.apache.hadoop.hive.ql.exec.mapredtask >>>>> >>>>> Hello all, >>>>> I have one query. It is executing fine on Hive CLI and returning the >>>>> result. >>>>> But when I am executing it with the help Hive JDBC I am getting error >>>>> as: >>>>> >>>>> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: >>>>> Execution Error, return code 2 from >>>>> org.apache.hadoop.hive.ql.exec.MapRedTask >>>>> at >>>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:192) >>>>> >>>>> What is the problem? Also I am starting the Hive Thrift Server through >>>>> Shell Script. (I have written a shell script which has commad to start >>>>> Hive >>>>> Thrift Server) >>>>> Later I decided to start Hive thrift Server manually by typing command >>>>> as: >>>>> >>>>> hadoop@ubuntu:~/hive-0.7.1$ bin/hive --service hiveserver >>>>> Starting Hive Thrift Server >>>>> org.apache.thrift.transport.TTransportException: Could not create >>>>> ServerSocket on address 0.0.0.0/0.0.0.0:10000 . >>>>> at >>>>> org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:99) >>>>> at >>>>> org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:80) >>>>> at >>>>> org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:73) >>>>> at org.apache.hadoop.hive.service.HiveServer.main(HiveServer.java:384) >>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>> at >>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>> at >>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:186) >>>>> hadoop@ubuntu:~/hive-0.7.1$ >>>>> >>>>> Please help me out from this. >>>>> Thanks >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Bhavesh Shah >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> ∞ >>>> Shashwat Shriparv >>>> >>>> >>>> >>> >>> >>> -- >>> >>> >>> ∞ >>> Shashwat Shriparv >>> >>> >>> >> >> >> -- >> Regards, >> Bhavesh Shah >> >> > > > -- > > > ∞ > Shashwat Shriparv > > > -- Regards, Bhavesh Shah