Hi,
We are trying to left join a table ( 536 records ) to another ( 780 records ).
However, getting this error message:
“This query cannot be planned possibly due to either a cartesian join or an inequality join”
The flag “planner.enable_nljoin_for_scalar_only” is set.
Anything regards setting we’re missing, how else to join a table without having an error .
Thank you
1 Like
@acornea
Can you attach the job profile here to check the error.
@Venugopal_Menda
I had the same issue with errror message after migrating to 3.2
“This query cannot be planned possibly due to either a cartesian join or an inequality join”
I’ve tested with flag planner.enable_nljoin_for_scalar_only enabled and disabled, but still the message was remaining.
I needed to rollback to 3.1.11 because of that.