QSM-02091: mv references a non-repeatable or session-sensitive expression

QSM-02091: mv references a non-repeatable or session-sensitive expression
Cause: The capability in question is not supported when the materialized view uses an expression that may not return the same value each time it is invoked against the same set of rows or that may return different values depending on session parameters.
Action: Re-phrase the query to avoid the use of such expressions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02091：mv引用不可重复或会话敏感的表达式,
.原因：当物化视图使用一个表达式时，不支持该问题的能力，该表达式在每次针对同一组行调用时可能不返回相同的值，或者可能会根据会话参数返回不同的值。,
.操作：重新排序查询以避免使用此类表达式。,
.

aiaiDBA

13718043309

010-86462881

QSM-02091: mv references a non-repeatable or session-sensitive expression

1 个回答

相似问题