You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/05/16 12:26:00 UTC

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

     [ https://issues.apache.org/jira/browse/DRILL-8013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Turton closed DRILL-8013.
-------------------------------

> 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
>            Assignee: Vova Vysotskyi
>            Priority: Major
>             Fix For: 1.20.1
>
>
> 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.20.7#820007)