doris版本 4.0.6中SHOW STREAM LOAD加where条件报错跟说明不符合

Viewed 17

版本 4.0.6
SHOW STREAM LOAD from dp where Status='Success' ORDER BY StartTime DESC limit 1
这样查询报错,报错信息写的STATE,但结果显示字段是STATUS
detailMessage = Where clause should looks like: LABEL = "your_load_label", or LABEL LIKE "matcher", or STATE = "PENDING|ETL|LOADING|FINISHED|CANCELLED", or compound predicate with operator AND

image.png
另外希望where能加上 Table 这个字段进行过滤

1 Answers

当前 SHOW STREAM LOAD 的 WHERE 子句只支持解析LABEL 和 STATE ,这里是 STATE 不是 Status 。