[
https://issues.apache.org/jira/browse/CALCITE-7406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu updated CALCITE-7406:
---------------------------
Fix Version/s: 1.42.0
> Add abs function (enabled in Mongodb library)
> ---------------------------------------------
>
> Key: CALCITE-7406
> URL: https://issues.apache.org/jira/browse/CALCITE-7406
> Project: Calcite
> Issue Type: New Feature
> Components: mongodb-adapter
> Affects Versions: 1.41.0
> Reporter: terran2010
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.42.0
>
>
> The SQL：
> {code:java}
> select abs(pop) from zips {code}
> Currently reporting errors：
> {code:java}
> Caused by: java.lang.IllegalStateException: Unable to implement
> MongoToEnumerableConverter: rowcount = 100.0, cumulative cost = {30.0 rows,
> 30.1 cpu, 0.0 io}, id = 39
> MongoProject(EXPR$0=[ABS(CAST(ITEM($0, 'pop')):INTEGER)]): rowcount =
> 100.0, cumulative cost = {20.0 rows, 20.1 cpu, 0.0 io}, id = 37
> MongoTableScan(table=[[mongo_raw, zips]]): rowcount = 100.0, cumulative
> cost = {10.0 rows, 10.100000000000001 cpu, 0.0 io}, id = 13 {code}
> We can consider increasing support for the ABS function
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
