PDI Rows Of Data

Owned by Former user (Deleted)
Last updated: Oct 23, 2015 by Matt TuckerVersion comment
1 min read

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.