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.
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.
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
- output sql data to html with hyperlink
- Update all column names to be lowercase
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Query to get only numbers from a string
- SQL grouping result to half hour
- table is specified twice both as a target for INSERT and as separate source of data
- SQL to JSON Need Bracket for Array that can have multiple rows
- Find all occurrences of Substring and replace it with a special characters
- Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
- How to do aggregate raw sql with julian date in sqlite (with django)
- SQL Merge SOURCE order and OUTPUT order
- Notepad++/Eclipse sql code auto-indent option?
- Output of update statement does not show correct row number
- Map table to exactly one of three
- PostgreSQL - ERROR: column does not exist SQL state: 42703
- How to force evaluation of subquery before joining / pushing down to foreign server
- SQL SELECT TOP 1 FOR EACH GROUP
- Convert a date to timestamp in a join with interpolation
- How To CAST substring as a DATE
- batch update a column using sql
- Firebird SQL add empty rows in resultset
- How do I cast a timestamp column as a MM/DD/YYYY in BigQuery
- Parsing JSON with Oracle SQL without knowing incoming field names
- Selecting from random column in PL/SQL
- Simple Query to Grab Max Value for each ID
- How to programmatically check if row is deletable?