[DRILL-8013] Drill attempts to push "$SUM0" to JDBC storage plugin for AVG

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.1
• Component/s: Storage - JDBC
• Assignee: Vova Vysotskyi
• Reporter: James Turton
• Created: 19/Oct/21 12:12
• Updated: 16/May/22 12:25
• Resolved: 23/Apr/22 05:54

Description

When running a query that includes the AVG aggregate against a JDBC data source, Drill transforms AVG into SUM0 / COUNT.  COUNT is pushed down to the source correctly but SUM0 is pushed down as "$SUM0" instead of SUM, causing a syntax error.  More info is visible at the link below.

 

http://mail-archives.apache.org/mod_mbox/drill-user/202110.mbox/[e-mail]%3E