[DRILL-3541] Average does not work with intervals

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Fix Version/s: Future
• Component/s: Query Planning & Optimization
• Labels: interval
• Assignee: Unassigned
• Reporter: Stefán Baxter
• Created: 22/Jul/15 14:45
• Updated: 10/Nov/15 18:28

Description

avg(<some-interval-value>) returns:

Error: SYSTEM ERROR: SchemaChangeException: Failure while materializing expression.
Error in expression at index 0. Error: Missing function implementation: [$sum0(INTERVALDAY-OPTIONAL)]. Full expression: null.
Fragment 1:2
[Error Id: 80171750-ac7b-4910-9319-8f4420f2b07f on localhost:31010] (state=,code=0)

in my case this is the result of avg(<timestamp>-<timestamp>).