PDI Rows Of Data
- Former user (Deleted)
- Matt Tucker
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.