QSM-02106: mv uses a filter condition in the WHERE or HAVING clause

QSM-02106: mv uses a filter condition in the WHERE or HAVING clause
Cause: The capability in question is not supported when the materialized view includes a filter condition in the WHERE or HAVING clause.
Action: Re-phrase the query to avoid the use of filter conditions in the WHERE or HAVING clauses.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02106：mv在WHERE或HAVING子句中使用过滤条件,
.原因：当物质化视图在WHERE或HAVING子句中包含过滤条件时，不支持该问题的能力。,
.操作：重新排序查询以避免在WHERE或HAVING子句中使用过滤条件。,
.

aiaiDBA

13718043309

010-86462881

QSM-02106: mv uses a filter condition in the WHERE or HAVING clause

1 个回答

相似问题