[CALCITE-6636] Refactor the Filter operator of Arrow ArrowAdapter

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.38.0
• Fix Version/s: 1.39.0
• Component/s: arrow-adapter
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 5 days ago 16:21
• Updated: 4 days ago 09:10

Description

Recently, I tried to complete https://issues.apache.org/jira/browse/CALCITE-6293
I found a problem. When building the Filter operator structure, we did not effectively fill the List<TreeNode> conditionNodes according to operators such as and and or, so our current Filter operator structure can only support the and operator
Currently, I have a way to support simple or operators, but I cannot support complex nested and+or and other operator joint queries, such as

String sql = "select \"intField\", \"stringField\"\n"
+ "from arrowdata\n"
+ "where (\"intField\" > 1 and \"stringField\" = '2') or \"intField\" = 0";

I plan to add operator information to List<TreeNode> conditionNodes so that we can finally assemble a suitable Filter structure