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 Zou2023年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 !
Thanks, ok standard contract it as __implementation-defined__, now it`s
clear.
- RelDataTypeSystemImpl#deriveSumType question. stanilovsky evgeny
- Re: RelDataTypeSystemImpl#deriveSumType question. Dan Zou
- Re: RelDataTypeSystemImpl#deriveSumType questi... stanilovsky evgeny
