QSM-02067: no partition key or PMARKER or join dependent expression in select list

QSM-02067: no partition key or PMARKER or join dependent expression in select list
Cause: The capability in question is not supported when the materialized view unless the select list (and group by list if a GROUP BY clause is present) includes the partition key or PMARKER function reference to the table in question or an expression join dependent on the partitioning column of the table in question.
Action: Add the partition key or a PMARKER function reference or a join dependent expression to the select list (and the GROUP BY clause, if present).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02067：选择列表中没有分区键或PMARKER或连接依赖表达式,
.原因：当物理视图除非选择列表（和按列表分组，如果存在GROUP BY子句）包含有关表的分区键或PMARKER函数引用或依赖于有关表的分区列。,
.操作：将分区键或PMARKER函数引用或连接依赖表达式添加到选择列表（如果存在则为GROUP BY子句）。,
.

aiaiDBA

13718043309

010-86462881

QSM-02067: no partition key or PMARKER or join dependent expression in select list

1 个回答

相似问题