Skip to main content
Pentaho Documentation

Data Types

The following data types are available for retrieval from the Kettle environment by using the Get System Info step:

Data Type Description
system date (variable) Current system time. Changes each time you request the date.
system date (fixed) The system time at the start of the transformation.
start date range (Transformation)   Start of date range, based on information in the ETL log table. See Transformation Settings.
end date range (Transformation)     End of date range, based on information in the ETL log table. See Transformation Settings.
start data range (Job) Start of date range based on information in the ETL log table. See Transformation Settings
End date range (Job) End of date range based on information in the ETL log table. See Transformation Settings.
Yesterday 00:00:00 Start of yesterday.
Yesterday 23:59:59 End of yesterday.
Today 00:00:00 Start of today.
Today 23:59:59 End of today.
Tomorrow 00:00:00 Start of tomorrow.
Tomorrow 23:59:59 End of tomorrow.
First day of last month 00:00:00 Start of last month.
Last day of last month 23:59:59 End of last month.
First day of this month 00:00:00 Start of this month.
Last day of this month 23:59:59 End of this month.
First day of next month 00:00:00 Start of next month.
Last day of next month 23:59:59 End of next month.
copy of step Copy number of the step. See Launching Several Copies of a Step.
Transformation name The name of the transformation.
Transformation file name The file name of the transformation (XML only).
User that modified the transformation last The user name of the last user who modified the transformation.
Date when the transformation was modified last Date and time when the transformation was last modified.
Transformation batch ID The ID_BATCH value in the logging table. See Transformation Settings.
Parent job batch ID

The PDI batch ID of the parent job taken from the job logging table. You need to enable logging in the job and set "Pass batch ID" in the job settings.

Hostname The hostname of the server.
IP address The IP address of the server.
Command line argument 1 Argument 1 on the command line.
Argument 1 on the command line. Argument 2 on the command line.
Command line argument 3 Argument 3 on the command line.
Command line argument 4 Argument 4 on the command line.
Command line argument 5 Argument 5 on the command line.
Command line argument 6 Argument 6 on the command line.
Command line argument 7 Argument 7 on the command line.
Command line argument 8 Argument 8 on the command line.
Command line argument 9 Argument 9 on the command line.
Command line argument 10 Argument 10 on the command line.
Kettle version The Kettle version (for example: 8.1.0).
Kettle Build Version The build version of the core Kettle library (for example: 27).
Kettle Build Date The build date of the core Kettle library.
Current process identifier (PID) The PID under which the Java process is currently running.
JVM max memory The maximum memory size (in bytes) that the JVM will attempt to use.
JVM total memory The memory size (in bytes) in the JVM.
JVM free memory The memory size (in bytes) free in the JVM.
JVM available memory The memory size (in bytes) that is available for the JVM to use.
Available processors The number of available processors on this computer system.
JVM CPU time (milliseconds) The number of milliseconds it takes the JVM’s CPU to complete a clock cycle.
Total physical memory size (bytes) The memory size (in bytes) available on this computer system.
Total swap space size (bytes) The memory size (in bytes) in swap space on this computer system.
Committed virtual size (bytes) The memory size (in bytes) of virtual memory used by the JVM.
Free physical memory size (bytes) The memory size (in bytes) of free to the computer system.
Free swap space size (bytes) The memory size (in bytes) free in the swap space on this computer system.
First day of last week 00:00:00 The date of last week’s Sunday.
Last day of last week 23:59:59 The date of last week’s Saturday.
Last working day of last week 23:59:59 The date of last week’s Friday.
First day of last week 00:00:00 (US) The date of last week’s Sunday (US time).
Last day of last week 23:59:59 (US) The date of last week’s Saturday (US time).
First day of this week 00:00:00 The date of this week’s Sunday.
Last day of this week 23:59:59 The date of this week’s Saturday.
Last working day of this week 23:59:59 The date of this week’s Friday.
First day of this week 00:00:00 (US) The date of this week’s Sunday (US time)
Last day of this week 23:59:59 (US) The date of this week’s Saturday (US time).
First day of next week 00:00:00 The date of next week’s Sunday
Last day of next week 23:59:59 The date of next week’s Saturday.
Last working day of next week 23:59:59 The date of next week’s Friday.
First day of next week 00:00:00 (US) The date of the next week’s Sunday (US time).
Last day of next week 23:59:59 (US) The date of next week’s Saturday (US time).
First day of last quarter 00:00:00 The date of the first day of the previous quarter.
Last day of last quarter 23:59:59 The date of the last day of the previous quarter.
First day of this quarter 00:00:00 The date of the first day of the current quarter.
Last day of this quarter 23:59:59 The date of the last day of the current quarter.
First day of next quarter 00:00:00 The date of the first day of the next (upcoming) quarter.
Last day of next quarter 23:59:59 The date of the last day of the next (upcoming) quarter.
First day of last year 00:00:00 The date of the first day of the previous year.
Last day of last year 23:59:59 The date of the last day of the current year.
First day of this year 00:00:00 The date of the first day of the current year.
Last day of this year 23:59:59 The date of the last day of the current year.
First day of next year 00:00:00 The date of the first day of the next (upcoming) year.
Last day of next year 23:59:59 The date of the last day of the next (upcoming) year.
Previous job entry result A Boolean representing the status of the previous job entry (Y=successful; N=failed).
Previous job entry exit status An Integer representing the exit status of the previous job entry.
Previous job entry nr An Integer representing the position of the previous entry in the job flow.
Previous job entry nr errors The number of errors from the previous job entry.
Previous job entry nr lines input The number of lines that came into the previous job entry.
Previous job entry nr lines output The number of lines that were sent out from the previous job entry.
Previous job entry nr lines read The number of lines that were read during the previous job entry.
Previous job entry nr lines updated The number of lines that were updated during the previous job entry.
Previous job entry nr lines written The number of lines that were written during the previous job entry.
Previous job entry nr lines deleted The number of lines that were deleted during the previous job entry.
Previous job entry nr lines rejected The number of lines that were rejected during the previous job entry.
Previous job entry nr rows The number of rows outputted by the previous job entry.
Previous job entry stopped A Boolean representing whether the previous job entry is stopped or not.
Previous job entry nr files The number of files that were accessed in the previous job entry.
Previous job entry nr files retrieved The number of files that were retrieved externally in the previous job entry.
Previous job entry log text The text log from the previous job entry.