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.
Hi Marc,
Welcome to Drill! Ok… let’s tackle this. Firstly, Drill uses more or less
standard ANSI SQL This means that constants are escaped with single quotes,
and fields are escaped with backpacks. Functions do not require the dollar
sign. Thus… Try this:
SELECT SUM( `ID`) AS `F0`,
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
Please MASK any privacy information at the attachments.
> 2021年10月7日 下午2:02,luoc 写道:
>
> Hi Prabhakar,
> Could you please post the error stack traces (in the log file) ? you can
> also send these messages as the email attachment for better.
>
>> 2021年10月6日 下午1:57,Prabhakar Bhosaale 写道:
Hi Prabhakar,
Could you please post the error stack traces (in the log file) ? you can also
send these messages as the email attachment for better.
> 2021年10月6日 下午1:57,Prabhakar Bhosaale 写道:
>
> Hi Luoc,
> Any pointers on the validation error mentioned in my last email? thanks in
> advance.