跳到主要内容
版本:2.1.3

Nulltf

Description

set default value for null field

提示

This transform only supported by engine Spark.

Options

nametyperequireddefault value
fieldsarrayno-

fields [list]

A list of fields whose default value will be set. The default value of the field can be set in the form of "field:value", If no set, the default value will be set according to the field type.

Examples

the configuration

  nulltf {
fields {
name: "",
price: 0,
num: 100,
flag: false,
dt_timestamp: "2022-05-18 13:51:40.603",
dt_date: "2022-05-19"
}
}

before use nulltf transform

+-----+-----+----+-----+--------------------+----------+
| name|price| num| flag| dt_timestamp| dt_date|
+-----+-----+----+-----+--------------------+----------+
|名称1| 22.5| 100|false|2022-05-20 14:34:...|2022-05-20|
| null| 22.5| 100|false|2022-05-20 14:35:...|2022-05-20|
|名称1| null| 100|false|2022-05-20 14:35:...|2022-05-20|
|名称1| 22.5|null|false|2022-05-20 14:36:...|2022-05-20|
|名称1| 22.5| 100| null|2022-05-20 14:36:...|2022-05-20|
|名称1| 22.5| 100|false| null|2022-05-20|
|名称1| 22.5| 100|false|2022-05-20 14:37:...| null|
+-----+-----+----+-----+--------------------+----------+

after use nulltf transform

+-----+-----+----+-----+--------------------+----------+
| name|price| num| flag| dt_timestamp| dt_date|
+-----+-----+----+-----+--------------------+----------+
|名称1| 22.5|100|false|2022-05-20 14:34:...|2022-05-20|
| | 22.5|100|false|2022-05-20 14:35:...|2022-05-20|
|名称1| 0.0|100|false|2022-05-20 14:35:...|2022-05-20|
|名称1| 22.5|100|false|2022-05-20 14:36:...|2022-05-20|
|名称1| 22.5|100|false|2022-05-20 14:36:...|2022-05-20|
|名称1| 22.5|100|false|2022-05-18 13:51:...|2022-05-20|
|名称1| 22.5|100|false|2022-05-20 14:37:...|2022-05-19|
+-----+-----+---+-----+--------------------+----------+