Follow the steps below to create a job to
process managed tables in Hive.
-
Select in the PDI client window to create a new job.
A new canvas opens.
-
On the Design tab, click General
and then double-click Start.
The Start entry appears on the canvas.
-
Under General, double-click
Transformation.
The Transformation entry appears on the canvas and
is connected by a hop from the Start entry.
-
Double-click the Transformation entry.
The Transformation entry dialog box
appears.
-
Browse to your saved Table input KTR file, then enter a
name, such as Table_In. Click OK
to save the entry.
-
Under General, double-click
Transformation.
The Transformation entry appears on the canvas and
is connected by a hop from the previous Transformation
entry.
-
Double-click the Transformation entry.
The Transformation entry dialog box
appears.
-
Browse to your saved Table output KTR file, then enter a
name such as Table_Out. Click OK
to save the entry.
-
(Optional) Add a Dummy entry joined by an error hop to
each Transformation entry to handle any false
results.
-
Under General, double-click
Success.
The Success entry appears on the canvas and is
connected by a hop from the Transformation
entry.
-
Click and enter a name for the file. Save it.
-
Press Run to execute the job.
The following example illustrates the job on the canvas:
The content of your managed table in Hive was correctly processed
using the job.