https://calcite.apache.org/javadocAggregate/org/apache/calcite/rel/rules/ReduceExpressionsRule.ProjectReduceExpressionsRule.html
Calcite has a very powerful constant folding optimizer. Mihai ________________________________ From: Hongyu Guo <[email protected]> Sent: Thursday, January 4, 2024 4:16:31 AM To: [email protected] <[email protected]> Subject: Simplify function with constant parameters Hi devs, Function with constant parameters can be simplified, for example ``` select abs(-1) as a, sqrt(4) as b; can be simplified as select 1 as a, 2.0 as b; ``` The execution of the function occurs during planning rather than during runtime. I noticed that Spark supports this simplification. Can Calcite also support it? I can log a new jira if you agree. Best, Hongyu
