You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "MinJi Kim (JIRA)" <ji...@apache.org> on 2017/08/16 01:44:00 UTC

[jira] [Created] (CALCITE-1945) Allow custom return types for AVG/VARIANCE/STDDEV/COVAR

MinJi Kim created CALCITE-1945:
----------------------------------

             Summary: Allow custom return types for AVG/VARIANCE/STDDEV/COVAR
                 Key: CALCITE-1945
                 URL: https://issues.apache.org/jira/browse/CALCITE-1945
             Project: Calcite
          Issue Type: Bug
            Reporter: MinJi Kim
            Assignee: Julian Hyde


For example, return types of AVG() is the input type. So, if the input is INT/BIGINT type, AVG() is always truncated.  Depending on the database, some database follow this behavior while others (e.g. Oracle/MySQL/etc.) do not and return floating point values for AVG(). 

Similar for other functions mentioned here.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)