This doe look like a bug in Avatica, indeed. Maybe you can file an issue on the JIRA. https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-5990?filter=a llopenissues You should provide enough instructions to reproduce this bug.
Mihai -----Original Message----- From: Egor Ryashin Sent: Friday, October 20, 2023 4:06 AM To: [email protected] Subject: Re: ClassCastException: class java.lang.Long cannot be cast to class java.lang.Float so, this works (with double): SELECT cast(1.0 as double) m3 from "wikipedia" > On 20 Oct 2023, at 14:01, Egor Ryashin <[email protected]> wrote: > > what I see in the debugger > > >> On 19 Oct 2023, at 18:47, Egor Ryashin <[email protected]> wrote: >> >> There wasn't one >> >> On Thu, Oct 19, 2023, 18:32 Mihai Budiu <[email protected] <mailto:[email protected]>> wrote: >>> Can you provide a stack trace? >>> ________________________________ >>> From: Egor Ryashin <[email protected] >>> <mailto:[email protected]>> >>> Sent: Thursday, October 19, 2023 6:47:48 AM >>> To: [email protected] <mailto:[email protected]> >>> <[email protected] <mailto:[email protected]>> >>> Subject: ClassCastException: class java.lang.Long cannot be cast to >>> class java.lang.Float >>> >>> Hi all, >>> >>> I have a strange error using Apache Druid avatica protobuf endpoint. >>> I send this query: >>> SELECT "user", >>> cast("added" as float) m3 >>> from "wikipedia" >>> limit 10 >>> >>> and get this: >>> ClassCastException: class java.lang.Long cannot be cast to class >>> java.lang.Float (java.lang.Long and java.lang.Float are in module >>> java.base of loader 'bootstrap') >>> >>> I wonder if it can be Avatica protobuf implementation? >>> >>> Thanks > > <PastedGraphic-1.png>
