[
https://issues.apache.org/jira/browse/CALCITE-7406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7406:
------------------------------------
Labels: pull-request-available (was: )
> 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
>
> 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)
