Hi all,
I'm running an alteryx workflow using a connection to HUE, but when a try to create a qvx file, the program sent the next Error: Data Stream Out (203): Error SQLExecute: [Hortonworks][Hardy] (35) Error from server: error code: '2' error message: 'Error while compiling statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 380, vertexId=vertex_1662580873033_1020401_7_53, diagnostics=[Vertex vertex_1662580873033_1020401_7_53 [Map 380] killed/failed due to:INIT_FAILURE, Fail to create InputInitializerManager, java.util.concurrent.ExecutionException: org.apache.tez.dag.api.TezReflectionException: Unable to instantiate class with 1 arguments: org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator
at com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:552)
at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:533)
at com.google.common.util.concurrent.FluentFuture$TrustedFuture.get(FluentFuture.java:86)
at org.apache.tez.dag.app.dag.RootInputInitializerManager.createInitializerWrappers(RootInputInitializerManager.java:144)
at org.apache.tez.dag.app.dag.
Could you guide me how to solve it?
Thanks in advance!
Hello,
Basically your workflow use too much memory and Hive cannot solve it. Two solutions:
1/improve/optimize your workflow
2/change your container size by changing server side properties on your odbc driver (advanced options)
property : hive.tez.container.value =4096MB (change value according to your use case ;) )
Best regards,
Simon