[jira] [Created] (DRILL-4952) AVG() returns SchemaChangeException

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-4952:
-------------------------------------

             Summary: AVG(<INTERVAL type>) returns SchemaChangeException
                 Key: DRILL-4952
                 URL: https://issues.apache.org/jira/browse/DRILL-4952
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.9.0
            Reporter: Khurram Faraaz


We need to fix the documentation if this is not supported, otherwise we need to fix the AVG function to accept INTERVAL type input.

As per Drill's documentation we say that AVG aggregate function accepts INTERVAL type as input
https://drill.apache.org/docs/aggregate-and-aggregate-statistical/

However, the below query fails when INTERVAL type value is passed as input to AVG function

{noformat}
0: jdbc:drill:schema=dfs.tmp> SELECT AVG(CAST(columns[0] AS INTERVAL YEAR)) from `durations.csv`;
Error: SYSTEM ERROR: SchemaChangeException: Failure while materializing expression.
Error in expression at index -1.  Error: Missing function implementation: [$sum0(INTERVALYEAR-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.

Fragment 0:0

[Error Id: 522f55c7-809a-4cf1-a926-3281f9837636 on centos-01.qa.lab:31010] (state=,code=0)
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)