Skip to main content
Pentaho Documentation

Data types

Parent article

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

Data TypeDescription
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:00Start of yesterday.
Yesterday 23:59:59End of yesterday.
Today 00:00:00Start of today.
Today 23:59:59End of today.
Tomorrow 00:00:00Start of tomorrow.
Tomorrow 23:59:59End of tomorrow.
First day of last month 00:00:00Start of last month.
Last day of last month 23:59:59End of last month.
First day of this month 00:00:00Start of this month.
Last day of this month 23:59:59End of this month.
First day of next month 00:00:00Start of next month.
Last day of next month 23:59:59End of next month.
copy of stepCopy number of the step. See Launching Several Copies of a Step.
Transformation nameThe name of the transformation.
Transformation file nameThe file name of the transformation (XML only).
User that modified the transformation lastThe user name of the last user who modified the transformation.
Date when the transformation was modified lastDate and time when the transformation was last modified.
Transformation batch IDThe ID_BATCH value in the logging table. See Transformation Settings.
Parent job batch IDThe 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.
HostnameThe hostname of the server.
IP addressThe IP address of the server.
Command line argument 1Argument 1 on the command line.
Argument 1 on the command line.Argument 2 on the command line.
Command line argument 3Argument 3 on the command line.
Command line argument 4Argument 4 on the command line.
Command line argument 5Argument 5 on the command line.
Command line argument 6Argument 6 on the command line.
Command line argument 7Argument 7 on the command line.
Command line argument 8Argument 8 on the command line.
Command line argument 9Argument 9 on the command line.
Command line argument 10Argument 10 on the command line.
Kettle versionThe Kettle version (for example: 8.1.0).
Kettle Build VersionThe build version of the core Kettle library (for example, 27).
Kettle Build DateThe build date of the core Kettle library.
Current process identifier (PID)The PID under which the Java process is currently running.
JVM max memoryThe maximum memory size (in bytes) that the JVM will attempt to use.
JVM total memoryThe memory size (in bytes) in the JVM.
JVM free memoryThe memory size (in bytes) free in the JVM.
JVM available memoryThe memory size (in bytes) that is available for the JVM to use.
Available processorsThe 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:00The date of last week’s Sunday.
Last day of last week 23:59:59The date of last week’s Saturday.
Last working day of last week 23:59:59The 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:00The date of this week’s Sunday.
Last day of this week 23:59:59The date of this week’s Saturday.
Last working day of this week 23:59:59The 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:00The date of next week’s Sunday
Last day of next week 23:59:59The date of next week’s Saturday.
Last working day of next week 23:59:59The 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:00The date of the first day of the previous quarter.
Last day of last quarter 23:59:59The date of the last day of the previous quarter.
First day of this quarter 00:00:00The date of the first day of the current quarter.
Last day of this quarter 23:59:59The date of the last day of the current quarter.
First day of next quarter 00:00:00The date of the first day of the next (upcoming) quarter.
Last day of next quarter 23:59:59The date of the last day of the next (upcoming) quarter.
First day of last year 00:00:00The date of the first day of the previous year.
Last day of last year 23:59:59The date of the last day of the current year.
First day of this year 00:00:00The date of the first day of the current year.
Last day of this year 23:59:59The date of the last day of the current year.
First day of next year 00:00:00The date of the first day of the next (upcoming) year.
Last day of next year 23:59:59The date of the last day of the next (upcoming) year.
Previous job entry resultA Boolean representing the status of the previous job entry (Y=successful; N=failed).
Previous job entry exit statusAn Integer representing the exit status of the previous job entry.
Previous job entry nrAn Integer representing the position of the previous entry in the job flow.
Previous job entry nr errorsThe number of errors from the previous job entry.
Previous job entry nr lines inputThe number of lines that came into the previous job entry.
Previous job entry nr lines outputThe number of lines that were sent out from the previous job entry.
Previous job entry nr lines readThe number of lines that were read during the previous job entry.
Previous job entry nr lines updatedThe number of lines that were updated during the previous job entry.
Previous job entry nr lines writtenThe number of lines that were written during the previous job entry.
Previous job entry nr lines deletedThe number of lines that were deleted during the previous job entry.
Previous job entry nr lines rejectedThe number of lines that were rejected during the previous job entry.
Previous job entry nr rowsThe number of rows outputted by the previous job entry.
Previous job entry stoppedA Boolean representing whether the previous job entry is stopped or not.
Previous job entry nr filesThe number of files that were accessed in the previous job entry.
Previous job entry nr files retrievedThe number of files that were retrieved externally in the previous job entry.
Previous job entry log textThe text log from the previous job entry.