[GitHub] [incubator-doris] li-ang-666 commented on issue #5094: 【bug】开启routineLoad的merge功能后，自动暂停，报错ReasonOfStateChanged: ErrorReason{code=errCode = 2, msg='failed to create task: errCode = 2, detailMessage = unknown reference column, column=__DORIS_DELETE_SIGN__, reference=del'}

[GitBox]

li-ang-666 commented on issue #5094:
URL: 
https://github.com/apache/incubator-doris/issues/5094#issuecomment-747170147


   和dev交流了一下，目前主要有2点：
   1、写在DELETE ON中的字段，在COLUMN中不能是衍生列。我的语句中del = XXXXXX，即为衍生列
   2、写在DELETE ON中的字段，必须对为null的情况做处理
   
   目前我使用
   DELETE ON del_ffaakkee is not null and del_ffaakkee != 0
   是可行的


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org