terran2010 created CALCITE-7406:
-----------------------------------
Summary: 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
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)
