QSM-01082: Joining materialized view, string, with table, string, not possible

QSM-01082: Joining materialized view, string, with table, string, not possible
Cause: A column in the query is not found in the summary. To obtain the column, a join back of materialized view to the table by means of either the primary key, foreign key or rowid of the table is required. The specified materialized view does not have the primary key, foreign key or rowid of the table to perform the join operation.
Action: Consider building a dimension-table to provide the missing information.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01082：连接物化视图，字符串，表，字符串，不可能,
.原因：摘要中找不到查询中的列。要获取列，需要通过表的主键，外键或rowid将实例化视图连接回表。指定的实例化视图没有表的主键，外键或rowid来执行连接操作。,
.操作：考虑构建维度表以提供缺少的信息。,
.

aiaiDBA

13718043309

010-86462881

QSM-01082: Joining materialized view, string, with table, string, not possible

1 个回答

相似问题