[CALCITE-6667] Arrow adapter should push down arithmetic operations

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.38.0
• Fix Version/s: 1.39.0
• Component/s: arrow-adapter
• Labels: pull-request-available
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 03/Nov/24 09:03
• Updated: 11/Nov/24 00:56

Description

Arrow adapter should push down arithmetic operations

Here is a simple case:

select  intField, stringField from arrowdata where floatField - 1 = 12

Its plan can be optimized to

    String plan = "PLAN=ArrowToEnumerableConverter\n"
        + "  ArrowProject(intField=[$0], stringField=[$1])\n"
        + "    ArrowFilter(condition=[=(+($2, 1.0:DECIMAL(2, 1)), 12.0E0)])\n"
        + "      ArrowTableScan(table=[[ARROW, ARROWDATA]], fields=[[0, 1, 2, 3]])\n\n";

Issue Links

• links to: GitHub Pull Request #4031