At times Hive error message could be misleading. I face similar error message while running query by embedding Hive in my application. Though actual error message in my case is, which is not propagated properly-
FAILED: Error in semantic analysis: Line 3:2 Invalid function abc See if you are doing something different on CLI. Thanks, Vinod On Fri, May 11, 2012 at 1:56 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > One more I problem I am facing is that, > My program is executing well, All queries are executing one after another > and giving the result. But there is a one query at which > always program gives me 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) > at PracticeExecutiveSummary.main(PracticeExecutiveSummary.java:127) > > I tried this on Hive CLi. It is giving result. I checked all logs but no > errors I found in it. > Actually What is the problem? Also in previous mail I post my errors which > are occured during running JAR. > What is that one? For what it is coming? > > Please tell me about it. > Thanks > > > On Fri, May 11, 2012 at 12:00 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > >> 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 >> >> > > > -- > Regards, > Bhavesh Shah > >