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 <[email protected]>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 <
> [email protected]> wrote:
>
>> have you added *hive_hbase-handler.jar* to your project
>>
>>
>> On Fri, May 11, 2012 at 10:13 AM, Bhavesh Shah
>> <[email protected]>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 <
>>> [email protected]> 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 <
>>>> [email protected]> 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 <[email protected]>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" <[email protected]>
>>>>>> To: [email protected], [email protected]
>>>>>> 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
