Caican Cai created CALCITE-6628:
-----------------------------------
Summary: Support Like Operator in Arrow adapter
Key: CALCITE-6628
URL: https://issues.apache.org/jira/browse/CALCITE-6628
Project: Calcite
Issue Type: New Feature
Components: arrow-adapter
Affects Versions: 1.37.0
Reporter: Caican Cai
Fix For: 1.39.0
example
{code:java}
@Test void testArrowProjectFieldsWithLike() {
String sql = "select \"intField\", \"stringField\"\n"
+ "from arrowdata\n"
+ "where \"stringField\" like '1%'";
String plan = "PLAN=ArrowToEnumerableConverter\n"
+ " ArrowProject(intField=[$0], stringField=[$1])\n"
+ " ArrowFilter(condition=[LIKE($1, '1%')])\n"
+ " ArrowTableScan(table=[[ARROW, ARROWDATA]], fields=[[0, 1, 2,
3]])\n\n";
String result = "intField=1; stringField=1\n"
+ "intField=10; stringField=10\n"
+ "intField=11; stringField=11\n"
+ "intField=12; stringField=12\n"
+ "intField=13; stringField=13\n"
+ "intField=14; stringField=14\n"
+ "intField=15; stringField=15\n"
+ "intField=16; stringField=16\n"
+ "intField=17; stringField=17\n"
+ "intField=18; stringField=18\n"
+ "intField=19; stringField=19\n";
CalciteAssert.that()
.with(arrow)
.query(sql)
.returns(result)
.explainContains(plan);
}
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
