英文:
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.
答案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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论