You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/12/16 08:58:26 UTC
[GitHub] [incubator-doris] li-ang-666 opened a new 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'}
li-ang-666 opened a new issue #5094:
URL: https://github.com/apache/incubator-doris/issues/5094
我的建表语句：
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[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'}
Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] yangzhg 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'}
Posted by GitBox <gi...@apache.org>.
yangzhg commented on issue #5094:
URL: https://github.com/apache/incubator-doris/issues/5094#issuecomment-750770292
这个问题的根源和 DELETE ON 条件没有关系，是 doris 在导入的时候不支持目前不支持 v1 , v2 = v1+1, v3 =v2+1 这种对于衍生列的引用表达式，我提了pr 修复了这个问题
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] yangzhg closed 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'}
Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #5094:
URL: https://github.com/apache/incubator-doris/issues/5094
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] li-ang-666 closed 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'}
Posted by GitBox <gi...@apache.org>.
li-ang-666 closed issue #5094:
URL: https://github.com/apache/incubator-doris/issues/5094
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org