Thanks for reporting this, we've filed a bug. https://issues.apache.org/jira/browse/DRILL-8013
On 2021/10/07 16:53, Dark Attraction wrote:
Hi Charles, Thank you for your quick response. I used drill webUI if I run select avg(`id`) from `postgres`.`public`.`Test` I have the following answer: org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. Sql: SELECT $SUM0("ID") AS "$f0", COUNT(*) AS "$f1" FROM "public"."Test" and the plan is 00-00 Screen 00-01 Project(EXPR$0=[$0]) 00-02 Project(EXPR$0=[divide(CastHigh(CASE(=($1, 0), null:NULL, $0)), $1)]) 00-03 Jdbc(sql=[SELECT $SUM0("id") AS "$f0", COUNT("id") AS "$f1" FROM "public"."Test" ]) so why drill sends $SUM0 instead of SUM I used drill 1.19.0 Le jeu. 7 oct. 2021 à 14:13, Dark Attraction <[email protected]> a écrit :Hi, I connected drill to postgres if I run a query like that: select avg(ID) from public.TEST I had this error message: Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. Sql: SELECT $SUM0("ID") AS "$f0", COUNT(*) AS "$f1" FROM "public"."TEST" I run drill 1.19.0 on docker Marc
