Join in Cognos Data Module returns error message

huangapple go评论64阅读模式
英文:

Join in Cognos Data Module returns error message

问题

I want to perform a simple join of two tables. Each Table has only one row.
The join column should be "DP". The Value for DP is "India" in both Tables. The Value comes from a calucation (see screenshot). When I perform the join (full outer join, 1 to 1, no filtering) I receive this error message:

> XQE-DAT-0001 Data source adapter error message:Detected implicit
> cartesian product for FULL OUTER join between logical plans Project
> [India AS DP#384910, Year_#369960, Net_Sales#369961]
> +- Relation[Year_#369960,Net_Sales#369961] parquet and Relation[Industry#369945,Value_#369946] parquet Join condition is
> missing or trivial.

英文:

I want to perform a simple join of two tables. Each Table has only one row.
The join column should be "DP". The Value for DP is "India" in both Tables. The Value comes from a calucation (see screenshot). When I perform the join (full outer join, 1 to 1, no filtering) I receive this error message:

> XQE-DAT-0001 Data source adapter error message:Detected implicit
> cartesian product for FULL OUTER join between logical plans Project
> [India AS DP#384910, Year_#369960, Net_Sales#369961]
> +- Relation[Year_#369960,Net_Sales#369961] parquet and Relation[Industry#369945,Value_#369946] parquet Join condition is
> missing or trivial.

Join in Cognos Data Module returns error message

Join in Cognos Data Module returns error message

Join in Cognos Data Module returns error message

答案1

得分: 1

你收到的错误消息表明你的查询中存在连接条件的问题。你正在进行一个完全外连接(FULL OUTER JOIN),但没有指定要连接的列,这类似于一个完全笛卡尔连接(称为“CROSS”连接)。

要解决这个问题,你需要指定一个有效的连接条件,以基于“DP”列将这些表关联起来。

英文:

The error message you received indicates that there is an issue with the join condition in your query. You're doing a FULL OUTER JOIN without specificy the column on which to join, which is similar to a full cartesian join (called "CROSS" join).

To fix this issue, you need to specify a valid join condition that relates the tables based on the "DP" column.

huangapple
  • 本文由 发表于 2023年5月17日 19:11:12
  • 转载请务必保留本文链接:https://go.coder-hub.com/76271452.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定