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
>
