### 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_
Activity
Weijun-H commentedon Mar 30, 2024
I think it should be related to the
compare_opfunction inarrow-rsWeijun-H commentedon Mar 30, 2024
track #5572
jayzhan211 commentedon Mar 30, 2024
There are many issues blocked by apache/arrow-rs#5426. Maybe I should pick up that challenging task again 😢