Hi stanilovsky, You can customize your behavior in RelDataTypeSystem. We have discussed this issue before, you could find more details in [1] and [2]. - [1] https://issues.apache.org/jira/browse/CALCITE-5604 - [2] https://issues.apache.org/jira/browse/CALCITE-1945
Best, Dan Zou > 2023年4月25日 19:14，stanilovsky evgeny <[email protected]> 写道： > > Hello ! > Probably can anyone explain why RelDataTypeSystemImpl#deriveSumType returns > INTEGER for incoming INTEGER type ? > I run simple: SELECT i, SUM(i) FROM integers i1 GROUP BY i ORDER BY i; and i > expect that return type will be BIGINT. > Did i miss something here ? > Thanks !
