James Turton created DRILL-8013: ----------------------------------- Summary: Drill attempts to push "$SUM0" to JDBC storage plugin for AVG Key: DRILL-8013 URL: https://issues.apache.org/jira/browse/DRILL-8013 Project: Apache Drill Issue Type: Bug Components: Storage - JDBC Affects Versions: 1.19.0 Reporter: James Turton Fix For: 1.20.0
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/%3ccags_q5dguiisdhk7lzxeytup322+ttxlayskdxhimj0g-qs...@mail.gmail.com%3E -- This message was sent by Atlassian Jira (v8.3.4#803005)