COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: tushar gaurav on 17 Oct 2022 11:47:11 PM

Title: Getting error while querying on Hive table from Cognos Analytics (11.2.1)
Post by: tushar gaurav on 17 Oct 2022 11:47:11 PM
Hi,

The data source test is successful however cognos fails to fetch data while viewing tablular data at query side in Reports.
While querying from Cognos (single table), we are getting the error:
-----------------------------
XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
RSV-SRV-0042 Trace back:
RSReportService.cpp(786): XQEException: CCL_CAUGHT: RSReportService::processImpl()
RSReportServiceMethod.cpp(260): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(887): XQEException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(331): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(932): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request
Execution/RSRenderExecution.cpp(589): XQEException: CCL_RETHROW: RSRenderExecution::execute
Assembly/RSDocAssemblyDispatch.cpp(341): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(450): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSReportPagesAssembly.cpp(183): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(386): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble
---------------------------------

Cognos Version: 11.2.1

Hive version: HIVE3.x



I have tried to put most of the information about the issue. Please let me know if need more information.

Appreciate any response/suggestions as this issue is impacting our delivery timelines.

Thanks,
Tushar Gaurav
Title: Re: Getting error while querying on Hive table from Cognos Analytics (11.2.1)
Post by: tushar gaurav on 01 Nov 2022 04:36:28 AM
We need to modify the connection string as below:

jdbc:hive2://ipaddress:10000/database_name?hive.execution.engine=tez;tez.queue.name=default;UseNativeQuery=1;max_number_of_sessions=3