Explaining the PDI data types

Data types are part of the metadata and are mandatory. Every field in a PDI dataset must have a data type. You have already used some of the most common data types, namely String, Date, and Integer, but the full available list of supported data types is a bit longer. The following table summarizes them all:

PDI data type

Java data type

Description

String

java.lang.String

Unlimited length text

Integer

java.lang.Long

A signed long (64-bit) integer

Number

java.lang.Double

A double precision floating point value

BigNumber

java.math.BigDecimal

Unlimited precision number

Date

java.util.Date

A date-time value with millisecond precision

Timestamp

java.sql.Timestamp ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.