You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/04/08 16:20:21 UTC
[jira] [Updated] (TAJO-742) Theta join support
[ 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)