Hitachi Vantara Pentaho Community Wiki
Child pages
  • PDI Rows Of Data

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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)

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="95aa030857659399-1d3e5be2-4a834d5b-a53e9a09-c74a13762ec50b2699769a4b"><ac:plain-text-body><![CDATA[

Binary

java.lang.byte[]

An array of bytes that contain any type of binary data.

]]></ac:plain-text-body></ac:structured-macro>

...

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

Wiki Markup
A row in PDI is comprised of one RowMetaInterface class to describe the row.&nbsp; 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.&nbsp; 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|#data-types] section.