QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs

QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs
Cause: When only multimv query rewrite is enabled, every query block should have at least one MV in it's from clause
Action: Disable only multimv query rewrite with ALTER SESSION SET "_ONLY_MULTIMV_QUERY_REWRITE_ENABLED" = false .

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01130：如果至少有一个查询块没有MV，则不允许多重MV重写,
.原因：当只启用multimv查询重写时，每个查询块应该在from子句中至少有一个MV,
.操作：仅使用ALTER SESSION SET“_ONLY_MULTIMV_QUERY_REWRITE_ENABLED”= false禁用multimv查询重写。,
.

aiaiDBA

13718043309

010-86462881

QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs

1 个回答

相似问题