QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query

QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query
Cause: All lossy joins in the materialized view must be present in the query for query rewrite to occur.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01071：查询重写是不可能的，因为在实例化视图％与表％中的连接已经消除了查询中发现的一些行,
.原因：物化视图中的所有有损耦合必须存在于查询中才能发生查询重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query

1 个回答

相似问题