map
根据表达式将记录映射到新的输出
根据表达式将记录映射到新的输出
属性
| 名称 | 类型 | 描述 | 必需 |
|---|---|---|---|
| expression | object, string |
表达式 |
是 |
| language | string |
语言 枚举： "jmespath", "sql" |
是 |
附加属性： 不允许
示例
source:
server_name: redislabs
schema: dbo
table: emp
transform:
- uses: map
with:
expression:
first_name: first_name
last_name: last_name
greeting: >-
'Hello ' || CASE WHEN gender = 'F' THEN 'Ms.' WHEN gender = 'M' THEN 'Mr.'
ELSE 'N/A' END || ' ' || full_name
country: country
full_name: full_name
language: sql
示例
source:
table: customer
transform:
- uses: map
with:
expression: |
{
"CustomerId": customer_id,
"FirstName": first_name,
"LastName": last_name,
"Company": company,
"Location":
{
"Street": address,
"City": city,
"State": state,
"Country": country,
"PostalCode": postal_code
},
"Phone": phone,
"Fax": fax,
"Email": email
}
language: jmespath
expression：object
表达式
无属性。