...
This page describes the gotcha's with respect to the VectorWise bulk loader step in PDI 4.2.0.
The company is now named Actian. The product is now named Vector. So this step should now be named the Actian Vector Bulk Loader. The interface has not changed. So this step is still working with all versions. There is also a clustered version Vector in Hadoop with the same interface (product name Vortex). This loader was tested with Actian Vector H Linux Version VH 4.0.1 and Kettle - Spoon GA Release - 5.3.0.0-213 on 30.March, 2015.
Load Alternatives
There are two different ways to load data, with a COPY TABLE SQL command, or with the tool vwload. Per default the sql command is used. To use the vwload tool, which is faster than the COPY TABLE alternative, remove any given 'Path to sql command', and check the box 'Use vwload as command, instead of sql'.
Operating systems
The VW bulk loader only runs under POSIX operating systems that support named pipes. This includes every modern operating system besides Windows.
...