mayankshriv opened a new issue, #13452:
URL: https://github.com/apache/pinot/issues/13452
It seems that the `EXPR_MIN/MAX` functions do not work in both v1 and v2
query engines.
Running a simple query like below errors out, even though there is no alias
in the query. On debugging, I see that the query never gets rewritten as
ExprMinMaxRewriter is not hooked up. I could also not find any config where the
rewriter could be configured.
* Any reason to not hookup the rewriter by default so the query can work?
* If there's one, how does one hook that rewriter up, is there a config?
```
SELECT
EXPR_MAX(balance,block_number)
FROM
org_2dYiMRMfas142XRKQ3bJIqmN3V6_base_erc20_balance_changes_block_v2_edea23a753f94dceae4c2b6d3fff50bd
WHERE token_address = lower('0x4200000000000000000000000000000000000006')
Query execution error on:
Server_pinot-server-5.pinot-server-headless.pinot.svc.cluster.local_8098
org.apache.pinot.spi.exception.BadQueryRequestException: Invalid aggregation
function: exprmax(balance,block_number); Reason: Aggregation function: EXPRMAX
is only supported in selection without alias.
```
cc: @jasperjiaguo @siddharthteotia @Jackie-Jiang
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
