Nullable Float values are rounded to the nearest integer when using tVerticaOutput in Copy mode

Problem Description

When writing a Float value, using an uppercase F, to Vertica with the tVerticaOutput component in Copy mode, the Float value is rounded off to the nearest integer. The same values, but with the schema set to not nullable (that is, a float with lowercase f) works fine, and decimals are retained in Vertica.

 

Root Cause

This is a known bug in Talend v6.5.1.

 

The Job design is shown below:

01_Job_Vertica_float_Float.PNG

 

The tMap component mappings are shown below:

 

03_tMap_1.PNG

 

Solution

 

Workaround (if applicable)

To workaround this issue, remove the 0 from the Precision setting in the Talend schema, as shown below:

Capture.PNG

Version history
Revision #:
5 of 5
Last update:
‎06-14-2019 09:20 PM
Updated by: