QSM-02090: SELECT includes an expression that is not just a column

QSM-02090: SELECT includes an expression that is not just a column
Cause: The capability in question is not supported when the materialized view uses an expression in the select list that is not a simple column reference.
Action: Re-phrase the query to avoid the use of the expressions that are not simple column references.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02090：SELECT包含不仅仅是列的表达式,
.原因：当物化视图使用select列表中不是简单列引用的表达式时，不支持该问题的功能。,
.操作：重新排序查询以避免使用不是简单列引用的表达式。,
.

aiaiDBA

13718043309

010-86462881

QSM-02090: SELECT includes an expression that is not just a column

1 个回答

相似问题