[jira] [Created] (TAJO-742) JoinOperators support other symbols besides "equals" symbol.

["Jaehwa Jung (JIRA)" <ji...@apache.org>]

Jaehwa Jung created TAJO-742:
--------------------------------

             Summary: JoinOperators support other symbols besides  "equals" symbol.
                 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)