QSM-01784: equivalence string has an anchor table string not found in query

QSM-01784: equivalence string has an anchor table string not found in query
Cause: A table in an equivalence is an anchor, if (a) it is not joined to any other table or (b) it is joined to other tables but each of its joins is not guaranteed to provide all the rows or joined with the above table being child-side table. If an anchor which is present in the equivalence is not found in the query, then query rewrite will not take place.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01784：等价字符串在查询中没有找到一个锚表字符串,
.原因：等价的表是一个锚，如果（a）它没有连接到任何其他表，或（b）它连接到其他表，但是每个连接不能保证提供所有行或与上表是儿童桌。如果在查询中找不到存在于等价项中的锚点，则不会发生查询重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01784: equivalence string has an anchor table string not found in query

1 个回答

相似问题