[CALCITE-6294] Support IN filter in Arrow adapter

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: arrow-adapter
• Assignee: Caican Cai
• Reporter: hongyu guo
• Created: 05/Mar/24 03:24
• Updated: 19/Jul/24 13:42

Description

For example:

select "intField", "stringField"
from arrowdata
where "intField" in (0, 1, 2)

will throw an exception

java.lang.AssertionError: cannot translate OR(=($0, 0), =($0, 1), =($0, 2))
	at org.apache.calcite.adapter.arrow.ArrowTranslator.translateMatch(ArrowTranslator.java:70)	at org.apache.calcite.adapter.arrow.ArrowTranslator.translateAnd(ArrowTranslator.java:109)	at org.apache.calcite.adapter.arrow.ArrowTranslator.translateMatch(ArrowTranslator.java:68)	at org.apache.calcite.adapter.arrow.ArrowFilter.<init>(ArrowFilter.java:43)	at org.apache.calcite.adapter.arrow.ArrowRules$ArrowFilterRule.convert(ArrowRules.java:97)	at org.apache.calcite.adapter.arrow.ArrowRules$ArrowFilterRule.onMatch(ArrowRules.java:87) 

See org.apache.calcite.adapter.arrow.ArrowAdapterTest#testArrowProjectFieldsWithInFilter