QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
Cause: You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Action: Set your compatibility mode to 9.0 or higher or restructure the materialized view query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02149：带有此MV的ON COMMIT需要9.0兼容性或更高版本,
.原因：您已指定使用以下组合的物化视图：在WHERE子句中连接聚合过滤条件FROM列表中的远程关系不带相应COUNT（x）函数的SUM（x）函数省略COUNT（* ）在少于9.0的兼容性模式下运行时，将集合函数与REFRESH ON COMMIT选项结合使用MIN（）或MAX（）聚合函数。,
.操作：将兼容模式设置为9.0或更高版本，或重构物化视图查询。,
.

aiaiDBA

13718043309

010-86462881

QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

1 个回答

相似问题