SAP Knowledge Base Article - Preview

2380345 - <Hive_host>.runtime.io.sort.mb 1216 should be larger than 0 and should be less than the available task memory (MB):538 - SDI

Symptom

When creating a remote connection to a Hive Database using SDI, a status of 'Pending' remains.

Check the dpagent_stdout.log file for an error similar to the following:

2016-09-28 09:34:29,626 [ERROR] WorkerThread.processStreamingExecuteStatement  - Error while processing statement: FAILED: 
Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.<Hive_Host>.<HiveHost>Task. Vertex failed, vertexName=Map 1, 
vertexId=vertex_1474972652183_0100_1_00, diagnostics=[Task failed, taskId=task_1474972652183_0100_1_00_000002, 
diagnostics=[TaskAttempt 0 failed, 
info=
[Error: Failure while running task:java.lang.IllegalArgumentException: 
<Hive_host>.runtime.io.sort.mb 1216 should be larger than 0 and should be less than the available task memory (MB):538


Read more...

Environment

SAP HANA Database 1.0

Product

SAP HANA 1.0, platform edition

Keywords

EIM, HIVE, Adapter, runtime.io.sort.mb, HiveAdapter.open, SDA Request for HiveAdapter of type STREAMING_SET_STATEMENT com.sap.hana.dp.adapter.sdk.AdapterException, Vertex failed , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.