CHANGE_DATA_TYPE
Changes the data type of an existing column.
If a column value can’t be converted to the new type, it will be replaced with NULL. This can happen when a string column is converted to an integer column. For example, string "123" will become integer 123, but string "ABC" cannot become a number, so it will be replaced with a NULL value.
Parameters
-
sourceColumn
– The name of an existing column. -
columnDataType
– New type of the column. The following data types are supported:-
byte: 1-byte signed integer numbers. The range of numbers is from -128 to 127.
-
short: 2-byte signed integer numbers. The range of numbers is from -32768 to 32767.
-
int: 4-byte signed integer numbers. The range of numbers is from -2147483648 to 2147483647.
-
long: 8-byte signed integer numbers. The range of numbers is from -9223372036854775808 to 9223372036854775807.
-
float: 4-byte single-precision floating point numbers.
-
double: 8-byte double-precision floating point numbers.
-
decimal: Signed decimal numbers with up to 38 digits total and 18 digits after the decimal point.
-
string: Character string values.
-
boolean: Boolean type has one of two possible values: `true` and `false` or `yes` and `no`.
-
timestamp: Values comprising fields year, month, day, hour, minute, and second.
-
date: Values comprising fields year, month and day.
-
Example
{ "RecipeAction": { "Operation": "CHANGE_DATA_TYPE", "Parameters": { "sourceColumn": "columnName", "columnDataType": "boolean" } } }