[
https://issues.apache.org/jira/browse/CALCITE-6628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17890249#comment-17890249
]
Julian Hyde commented on CALCITE-6628:
--------------------------------------
You didn't change the summary.
> Support Like Operator in Arrow adapter
> --------------------------------------
>
> Key: CALCITE-6628
> URL: https://issues.apache.org/jira/browse/CALCITE-6628
> Project: Calcite
> Issue Type: Sub-task
> Components: arrow-adapter
> Affects Versions: 1.37.0
> Reporter: Caican Cai
> Assignee: Caican Cai
> Priority: Major
> Fix For: 1.39.0
>
>
> Currently, the Arrow adapter of Calcite does not support the like operator.
> For example
> {code:java}
> String sql = "select \"intField\", \"stringField\"\n"
> + "from arrowdata\n"
> + "where \"stringField\" like '1%'";
> String plan = "PLAN=EnumerableCalc(expr#0..1=[{inputs}], expr#2=['1%'],
> expr#3=[LIKE($t1, $t2)], proj#0..1=[{exprs}], $condition=[$t3])\n"
> + " ArrowToEnumerableConverter\n"
> + " ArrowProject(intField=[$0], stringField=[$1])\n"
> + " ArrowTableScan(table=[[ARROW, ARROWDATA]], fields=[[0, 1, 2,
> 3]])\n\n";
> {code}
> After support, it is as follows
> {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";
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
