QSM-02010: join predicate with operator other than equals (=)

QSM-02010: join predicate with operator other than equals (=)
Cause: The capability in question is not supported when the materialized uses a relationship operator other than equals ("=") in a join in the WHERE clause. This is known as a non-equijoin.
Action: Re-phrase the query to avoid the non-equijoin.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02010：与等于（=）以外的运算符连接谓词,
.原因：当物质化在WHERE子句中的连接中使用equals（“=”）之外的关系运算符时，不支持该问题的能力。这被称为非等式。,
.操作：重新排序查询以避免非等价。,
.

aiaiDBA

13718043309

010-86462881

QSM-02010: join predicate with operator other than equals (=)

1 个回答

相似问题