Skip to content

Add SQL support for IN expression #118

Closed

Description

@alamb

Note: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-10731

We should add support for the SQL "IN" expression.

See TPC-H query 12 for a good example:
{code:java}
WHERE l_shipmode IN ('MAIL', 'SHIP') {code}
 

Activity

  1. Ted-Jiang commented on Jan 11, 2022

    @Ted-Jiang
    Member

    i will have a try. i think its a good chance to familiar datafusion code.😁

  2. Ted-Jiang commented on Jan 11, 2022

    @Ted-Jiang
    Member

    it seems already support in where col1 in (1,2) in in_list.rs @alamb

  3. Ted-Jiang commented on Jan 11, 2022

    @Ted-Jiang
    Member

    but in for a sub_query is not support, should i implement this?

  4. alamb commented on Jan 11, 2022

    @alamb
    ContributorAuthor

    Thanks @Ted-Jiang you are right! @seddonm1 added support in 93c6c88

    I think @xudong963 has been working on some subqueries (e.g. #1209 and #1373 / #1492) so it might be good to catch up on those efforts.

  5. alamb commented on Jan 11, 2022

    @alamb
    ContributorAuthor

    There were some attempts to improve the performance of INLIST here: #806 #278 from @Dandandan and @pjmore

  6. xudong963 commented on Jan 11, 2022

    @xudong963
    Member

    I think @xudong963 has been working on some subqueries (e.g. #1209 and #1373 / #1492) so it might be good to catch up on those efforts.

    Yes, I'm sure I'll continue with this weekend. BTW, I'll split some small tasks, @Ted-Jiang you can help me. There is a paper that you can read in advance. "Execution Strategies for SQL Subqueries"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesthelp wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions