Affects Version/s: None
Fix Version/s: 0.9.0
Currently Tajo doesn't support a filter OUTER JOIN's ON clause.
or has some bugs. There is some rules for this in the following urls.
Briefly summarized as follows.
- Join Predicate on Preserved Row Table: Used for join condition(not filter)
- Join Predicate on Null Supplying Table: Can push down to the table scan
- Where Predicate on Preserved Row Table: Can push down to the table scan
- Where Predicate on Null Supplying Table: Used for filter with join result data. This filter condition is attached to SELECTION Node.