[
https://issues.apache.org/jira/browse/TAJO-742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-742:
------------------------------
Summary: Theta join support (was: JoinOperators support other symbols
besides "equals" symbol.)
> Theta join support
> ------------------
>
> Key: TAJO-742
> URL: https://issues.apache.org/jira/browse/TAJO-742
> Project: Tajo
> Issue Type: Sub-task
> Components: physical operator
> Reporter: Jaehwa Jung
> Assignee: Jaehwa Jung
>
> You can use various symbols for join conditions as follows:
> ||Symbol||Words||Example||
> |=| equals|1 + 1 = 2|
> |!=|not equal to|1 + 1 != 1|
> |>|greater than|5 > 2|
> |<| less than|7 > 9|
> |>=|greater than or equal to|id >= 1|
> |<=|less than or equal to|id <= 2|
> But unfortunately, if you use other symbols besides _equals_ symbol for join
> conditions, you can't find your expected result. Because HashJoinExec and
> MergeJoinExec just focus on _equals_ sign.
> Thus, we need to improve JoinOperators for various symbols. Additionally, we
> also should update Shuffle and Hashing codes.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
