You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2021/10/19 12:13:00 UTC
[jira] [Created] (DRILL-8013) Drill attempts to push "$SUM0" to
JDBC storage plugin for AVG
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-qSkCw@mail.gmail.com%3E
--
This message was sent by Atlassian Jira
(v8.3.4#803005)