[
https://issues.apache.org/jira/browse/CALCITE-6618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17890111#comment-17890111
]
Caican Cai commented on CALCITE-6618:
-------------------------------------
[~julianhyde]Thanks, updated
> Support NOT EQUALS operator in Arrow adapter
> --------------------------------------------
>
> Key: CALCITE-6618
> URL: https://issues.apache.org/jira/browse/CALCITE-6618
> Project: Calcite
> Issue Type: Improvement
> Components: arrow-adapter
> Affects Versions: 1.37.0
> Reporter: Caican Cai
> Priority: Major
> Labels: pull-request-available
>
> Currently, Calcite's Arrow adapter does not support Not equal.
> For example，
> {code:java}
> String sql = "select \"intField\", \"stringField\"\n"
> + "from arrowdata\n"
> + "where \"intField\" <> 12";
> {code}
> {code:java}
> String plan = "PLAN=EnumerableCalc(expr#0..1=[{inputs}], expr#2=[12],
> expr#3=[<>($t0, $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}
> It can be optimized to
> {code:java}
> String plan = "PLAN=ArrowToEnumerableConverter\n"
> + " ArrowProject(intField=[$0], stringField=[$1])\n"
> + " ArrowFilter(condition=[<>($0, 12)])\n"
> + " ArrowTableScan(table=[[ARROW, ARROWDATA]], fields=[[0, 1, 2,
> 3]])\n\n";
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
