QSM-01602: equivalence, string, requires join back to table, string, on column, string

QSM-01602: equivalence, string, requires join back to table, string, on column, string
Cause: A column in the query does not appear in the equivalence. Query rewrite will try to obtain this column from the base table, by doing a join back to that column with a materialized view. But join backs are not allowed for equivalence rewrite as the required constraints are not guaranteed to be found on the tables in the destination statement of the equivalence.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01602：等价字符串，需要连接回表，字符串，列，字符串,
.原因：查询中的列不会出现在等价中。查询重写将尝试从基表获取此列，通过使用实例化视图连接回该列。但是，由于所需约束不能保证在等价目的语句中的表上找到，所以不允许加入后台进行等价重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01602: equivalence, string, requires join back to table, string, on column, string

1 个回答

相似问题