Support filter for ARRAY #9857
Description
Is your feature request related to a problem or challenge?
It would be nice if we could filter array type
statement ok
create table data (c1 int[]) as values
([1, 2, 3]),
([4, 5]),
([4, 5])
query error DataFusion error: Arrow error: Invalid argument error: Invalid comparison operation: List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\) == List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\)
select * from data where c1 = [1, 2, 3];
Expect: [1,2,3]
query error DataFusion error: Arrow error: Invalid argument error: Invalid comparison operation: List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\) == List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\)
select * from data where c1 = [4, 5];
Expect: [4, 5]
query error DataFusion error: Arrow error: Invalid argument error: Invalid comparison operation: List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\) == List\(Field \{ name: "item", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\)
select * from data where c1 = [1, 4];
Expect:
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response