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:[email protected]]
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 [email protected]<mailto:[email protected]> | 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)
