morningman commented on a change in pull request #4873:
URL: https://github.com/apache/incubator-doris/pull/4873#discussion_r520284308
##########
File path: docs/en/administrator-guide/load-data/routine-load-manual.md
##########
@@ -105,7 +105,7 @@ The detailed syntax for creating a routine load task can be
connected to Doris a
As another example, suppose the user needs to load a table containing only
a column of `k1` with a column type of `int`. And you need to process the
corresponding column in the source file: convert the negative number to a
positive number and the positive number to 100. This function can be
implemented with the `case when` function. The correct wording should be as
follows:
- `COLUMNS (xx, case when xx < 0 than cast(-xx as varchar) else cast((xx +
'100') as varchar) end)`
+ `COLUMNS (xx, k1 = case when xx < 0 thenn cast(-xx as varchar) else
cast((xx + '100') as varchar) end)`
Review comment:
```suggestion
`COLUMNS (xx, k1 = case when xx < 0 then cast(-xx as varchar) else
cast((xx + '100') as varchar) end)`
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
