CHANGE_DATA_TYPE - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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"
        }
    } 
 }