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/17 07:47:12 UTC
[GitHub] [incubator-doris] 4396clearlove7 opened a new issue #5103: doris怎么删除昨天的数据
4396clearlove7 opened a new issue #5103:
URL: https://github.com/apache/incubator-doris/issues/5103
delete from GROUP_FACT_DRP_SALE where date('LASTMODIFIEDTIME') = date(now()) -1
> 1064 - errCode = 2, detailMessage = Left expr of binary predicate should be column name
> 时间: 0.044s
delete from GROUP_FACT_DRP_SALE where LASTMODIFIEDTIME = date(now()) -1
----------------------------------------------------------------
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] chaoyli commented on issue #5103: doris怎么删除昨天的数据
Posted by GitBox <gi...@apache.org>.
chaoyli commented on issue #5103:
URL: https://github.com/apache/incubator-doris/issues/5103#issuecomment-747273297
需要强制写明时间，date(now())这种表达式在delete里面还不支持。
----------------------------------------------------------------
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] coderjiang commented on issue #5103: doris怎么删除昨天的数据
Posted by GitBox <gi...@apache.org>.
coderjiang commented on issue #5103:
URL: https://github.com/apache/incubator-doris/issues/5103#issuecomment-1060564080
mysql> DELETE FROM ods_order_report WHERE purchase_date_local >= DATE_ADD('2022-03-06 00:00:00', INTERVAL 1 day);
ERROR 1064 (HY000): errCode = 2, detailMessage = Right expr of binary predicate should be value
mysql> select DATE_ADD('2022-03-06 00:00:00', INTERVAL 1 day);
+-------------------------------------------------+
| date_add('2022-03-06 00:00:00', INTERVAL 1 day) |
+-------------------------------------------------+
| 2022-03-07 00:00:00 |
+-------------------------------------------------+
1 row in set (0.00 sec)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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] coderjiang commented on issue #5103: doris怎么删除昨天的数据
Posted by GitBox <gi...@apache.org>.
coderjiang commented on issue #5103:
URL: https://github.com/apache/incubator-doris/issues/5103#issuecomment-1060563392
DELETE FROM ods_order_report WHERE purchase_date_local >= DATE_ADD('2022-03-06 00:00:00', INTERVAL 1 day);
这语句也是不行的，会报错：
ERROR 1064 (HY000): errCode = 2, detailMessage = Right expr of binary predicate should be value
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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