QSM-01049: semi-join check failed for materialized view, string

QSM-01049: semi-join check failed for materialized view, string
Cause: If there is a semi join in the query, then Query Rewrite will create (select distinct , from mjv) where is the list of rowids/pk of all mjv tables that don't correspond to a right side of a semi-join and are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01049：实体化视图，字符串的半连接检查失败,
.原因：如果查询中有半连接，则Query Rewrite将创建（从mjv中选择distinct ，），其中是所有mjv的rowids / pk的列表与半连接的右侧不对应的表和是它们的列。如果来自物化视图的连接与查询中的半连接不匹配，则不会发生查询重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01049: semi-join check failed for materialized view, string

1 个回答

相似问题