Transformation does not complete execution

If you are using the Hive 2/3 connector with both the Table Input step and the Table Output step in the same transformation, your transformation does not complete its execution.

To resolve this issue, split the original transformation into two new transforms where one contains the Table Input step and other contains the Table Output step. You can control the order of execution with a PDI job. If you try to use a child transformation to control the execution order, the same issue occurs.

See Using Table input and Table output steps with AEL for managed tablles in Hive in the Pentaho Data Integration document for further instructions.