We have just configured a new Hive JDBC client with an upgraded support for per user Kerberos authentication. The JDBC file set applied which works fine in an alternate setup is: [cid:image002.png@01CF5B00.029301B0]
All Hive queries fail with a similar attached stack trace that at the bottom is a Hive error “Caused by: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask”. Any ideas as to what is the issue? Regards, ________________________________________ Vince George | Solutions Manager - Consultant Mobile: (201) 519-3777 vincg...@cisco.com<mailto:vincg...@cisco.com> | www.cisco.com<http://www.cisco.com/> [Description: cid:F9A08884-B7D9-4EB1-B808-54E75B51A1ED] This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message. For corporate legal information go to: http://www.cisco.com/web/about/doing_business/legal/cri/index.html
<<inline: image001.png>>
<<inline: image002.png>>
Unable to retrieve result from data source "/shared/PAMKerberosTests/HiveTestDS" during query execution. Failed query: "SELECT `aster`.`name`,`aster`.`city`,`aster`.`zip` FROM default.aster `aster` WHERE UPPER(TRIM(UPPER(`aster`.`zip`))) = '33418'". [data-3923000] Cause: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask com.compositesw.cdms.webapi.WebapiException: Unable to retrieve result from data source "/shared/PAMKerberosTests/HiveTestDS" during query execution. Failed query: "SELECT `aster`.`name`,`aster`.`city`,`aster`.`zip` FROM default.aster `aster` WHERE UPPER(TRIM(UPPER(`aster`.`zip`))) = '33418'". [data-3923000] Cause: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask Unable to retrieve result from data source "/shared/PAMKerberosTests/HiveTestDS" during query execution. Failed query: "SELECT `aster`.`name`,`aster`.`city`,`aster`.`zip` FROM default.aster `aster` WHERE UPPER(TRIM(UPPER(`aster`.`zip`))) = '33418'". [data-3923000] at com.compositesw.cdms.webapi.PrefetchCursor$LoadPipeThread.run(PrefetchCursor.java:273) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: Unable to retrieve result from data source "/shared/PAMKerberosTests/HiveTestDS" during query execution. Failed query: "SELECT `aster`.`name`,`aster`.`city`,`aster`.`zip` FROM default.aster `aster` WHERE UPPER(TRIM(UPPER(`aster`.`zip`))) = '33418'". [data-3923000] at com.compositesw.server.qe.QueryResult.next(SourceFile:311) at com.compositesw.cdms.webapi.PrefetchCursor$LoadPipeThread.run(PrefetchCursor.java:253) ... 3 more Caused by: Unable to retrieve result from data source "/shared/PAMKerberosTests/HiveTestDS" during query execution. Failed query: "SELECT `aster`.`name`,`aster`.`city`,`aster`.`zip` FROM default.aster `aster` WHERE UPPER(TRIM(UPPER(`aster`.`zip`))) = '33418'". [data-3923000] at com.compositesw.cdms.ds.jdbc.JdbcConnectionTableCursor.next(JdbcConnectionTableCursor.java:237) at com.compositesw.data.cursor.MeterCursor.next(MeterCursor.java:86) at com.compositesw.server.qe.physical.operator.SqlScan.next(SourceFile:742) at com.compositesw.server.qe.topology.SelectPTree.nextInternal(SourceFile:399) at com.compositesw.server.qe.topology.SelectPTree.next(SourceFile:378) at com.compositesw.server.qe.QueryResult.next(SourceFile:295) ... 4 more Caused by: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:161) at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:149) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:182) at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:246) at com.compositesw.cdms.ds.jdbc.JdbcConnectionTableCursor.createResultSet(JdbcConnectionTableCursor.java:465) at com.compositesw.cdms.ds.jdbc.JdbcConnectionTableCursor.next(JdbcConnectionTableCursor.java:190) ... 9 more at com.compositesw.cdms.webapi.WebapiException_SOAPSerializer.doDeserialize(WebapiException_SOAPSerializer.java:58) at com.sun.xml.rpc.encoding.ObjectSerializerBase.deserialize(ObjectSerializerBase.java:209) at com.sun.xml.rpc.encoding.ReferenceableSerializerImpl.deserialize(ReferenceableSerializerImpl.java:172) at com.compositesw.cdms.webapi.service.WMetaDataSvc_dataset_fetch_Fault_SOAPSerializer.deserializeDetail(WMetaDataSvc_dataset_fetch_Fault_SOAPSerializer.java:54) at com.sun.xml.rpc.encoding.SOAPFaultInfoSerializer.doDeserialize(SOAPFaultInfoSerializer.java:151) at com.sun.xml.rpc.encoding.ObjectSerializerBase.deserialize(ObjectSerializerBase.java:209) at com.sun.xml.rpc.encoding.ReferenceableSerializerImpl.deserialize(ReferenceableSerializerImpl.java:172) at com.compositesw.cdms.webapi.service.WMetaDataSvc_Stub._readBodyFaultElement(WMetaDataSvc_Stub.java:23032) at com.sun.xml.rpc.client.StreamingSender._send(StreamingSender.java:238) at com.compositesw.cdms.webapi.service.WMetaDataSvc_Stub.dataset_fetch(WMetaDataSvc_Stub.java:4358) at com.compositesw.cdms.webapi.WDataset$FetcherThread.run(WDataset.java:273) Version Information: Studio 6.2.6.00.31 (hotfix), Build ID 140324-101304-0700-74880, Server 6.2.6.00.31 (hotfix)