PDI Rows of data

This page describes how PDI handles rows of data.

Available data types

These are the available data types in PDI v3 and v4:

Kettle data type	Java data type	Description
String	java.lang.String	A variable (unlimited) length text encoded in UTF-8 (Unicode)
Integer	java.lang.Long	An signed long (64-bit) integer
Number	java.lang.Double	A double precision floating point value
BigNumber	java.math.BigDecimal	An arbitrary (unlimited) precision number
Date	java.util.Date	A date-time value with millisecond precision
Boolean	java.lang.Boolean	A boolean value (true or false)
Binary	java.lang.byte[]	An array of bytes that contain any type of binary data.

New data types in PDI 5:

Kettle data type	Java data type	Description
Timestamp	java.sql.Timestamp	A date-time value with nanosecond precision
Internet Address	java.net.InetAddress

Rows of data

A row in PDI is comprised of one RowMetaInterface class to describe the row. The row metadata contains everything you need to know about the rows like the names of the fields, the data types, the lengths, descriptions and much more. The row also contains 0, 1 or more rows of data in the form of a simple Object[]: array of java.lang.Object where each value contains either null or one of the data types listed in the available data types section.

Browser not supported