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.
- Postgres selecting from table row
- To find the next work day
- SQL Server Left Join With 'Or' Operator
- How to exclusivley select a record from different tables
- Add user to table and use users id while adding data to second table while user registration
- Selecting the earliest row where a specified date value falls between a date range (two columns) when multiple rows may match
- SQL AVG returning an int
- Using two tables. What am I doing wrong here?
- ORDER BY column, with specific notnull value LAST
- How to get the first available number in a range
- In GENERATE_SPREADSHEET SQL on IBM i there are problems if a $ character is present in qualified names
- How to return default value from SQL query
- how to sort a column which contains Semantic Version in Postgres
- Proper Case in Athena SQL
- SQL VBA Query not picking up letter characters, only fully numeric fields
- Joining two tables with a joint result in Postgresql
- Can I Query or Do I Need a Table Function?
- How to link 3 SQL tables and pass 0 value if the value is NULL
- Searching all tables in database containing specific column
- Convert VARCHAR to SMALLDATETIME as part of UPDATE statement
- WordPress - Optimize the Meta Query for 3 meta keys at a time
- How can I find the highest ancestor in a tree?
- Firebird lock and select unlocked fields
- How to pass parameters in a native query JPA
- SQL Server : query columns to JSON object with group by
- SQL Server While loop for last day of month
- Can anyone please explain this solution of hacker rank Binary Tree Nodes?
- generate DDL script from SQL Server database
- How to return name, given an ID Number from same dataset?
- Get the names of all the tables and the views in a single SQL query for SQL Server?