[TAJO-680] Improve the IN operator to support sub queries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: distributed query plan, SQL Parser
• Assignee: Jihoon Son
• Reporter: Jihoon Son
• Created: 07/Mar/14 15:35
• Updated: 14/Aug/15 05:32
• Resolved: 14/Aug/15 03:34

Description

Currently, the IN operator can be used with only sets of values.
We need to improve it to support sub queries as the following example query.

tajo> select * from nation where n_regionkey in (select r_regionkey from region); 

Issue Links

• duplicates: TAJO-596 IN and NOT IN clauses support
• relates to: TAJO-1561 Query which contains join condition in "OR" clause does not finish.
• relates to: TAJO-1310 Maintaining join filters in join operators
• relates to: TAJO-1666 Allow multiple columns for IN predicates

Sub-Tasks

• Add query plan tests for IN subquery: Open