Access Keys:
Skip to content (Access Key - 0)

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.


This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder (4.2.0) Powered by Atlassian Confluence 3.3.3, the Enterprise Wiki