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
