Getting error while querying on Hive table from Cognos Analytics (11.2.1)

[tushar gaurav]

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

[tushar gaurav]

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