[
https://issues.apache.org/jira/browse/CALCITE-6618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17890253#comment-17890253
]
Julian Hyde commented on CALCITE-6618:
--------------------------------------
Too late now, but "Support '<>' in Arrow adapter" would have been better. Use
SQL keywords in summaries whenever possible. 'NOT EQUALS' is not SQL.
> Support NOT EQUALS operator in Arrow adapter
> --------------------------------------------
>
> Key: CALCITE-6618
> URL: https://issues.apache.org/jira/browse/CALCITE-6618
> Project: Calcite
> Issue Type: Sub-task
> Components: arrow-adapter
> Affects Versions: 1.37.0
> Reporter: Caican Cai
> Assignee: Caican Cai
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
>
> 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)
