Updated on 2022-09-15 GMT+08:00

EL Operation

Overview

The EL Operation operator calculates field values and generates new fields. The algorithms that are currently supported include md5sum, sha1sum, sha256sum, and sha512sum.

Input and Output

  • Input: fields to be converted
  • Output: fields generated after the EL expression conversion

Parameter Description

Table 1 Operator parameter description

Parameter

Description

Type

Mandatory

Default Value

Field generated by el operation

EL expression configuration:

  • name: Name of the expression output result.
  • el expression: Expression. The format is expression name(input field name,value indicating whether to use lower case letters to indicate the output result), for example, md5sum(fieldname,true).
    • md5sum: generates md5 values.
    • sha1sum: generates sha1 values.
    • sha256sum: generates sha256 values.
    • sha512sum: generates sha512 values.
  • type: Type of the expression output result. VARCHAR is recommended.
  • date format: Format of the expression output result.
  • length: Length of the expression output result.

map

Yes

None

Data Processing Rule

  • The operator calculates fields values and generates new fields.
  • The type of the new fields can only be VARCHAR.

Example

Use the CSV File Input operator to generate fields A and B.

The following figure shows the source file.

Configure the EL Operation operator to generate fields C, D, E, and F.

Six fields are generated, as shown in the following figure.