Nitin, I don't see the attachment, maybe due to apache politics. Could you share it by google drive? Regarding explicit casting, nullable and non-nullable double are represented by different types inside Drill and cannot be cast that way. That may cause the error.
On Thu, Dec 6, 2018 at 5:55 PM Nitin Pawar <nitinpawar...@gmail.com> wrote: > Hello Anton, > Thanks for the reply. > I have tried explicit casting as well as with subquery mechanism > I have attached the parquet file along with this email > > following is the query > select covar_samp(cast(id_dist as double), cast(num2 as double)) from > dfs.tmp.`/nitin`; > > > On Thu, Dec 6, 2018 at 7:23 PM Anton Gozhiy <anton5...@gmail.com> wrote: > >> Hi Nitin Pawar, >> I was investigating this. Indeed, when one of the parameters has optional >> data mode, Drill cannot cast the parameters to the same type, and there is >> no "covar_samp" UDF that takes parameters with different types. >> To reproduce this, I used a nullable column, bu I'm not sure if it is your >> case. >> You mentioned that it depends on the float number size. >> It would be helpful if you share the whole query and describe what data >> did >> you use. >> >> >> On Thu, Dec 6, 2018 at 3:23 PM Nitin Pawar <nitinpawar...@gmail.com> >> wrote: >> >> > any help on this ?? >> > >> > just to put some more data on this >> > if a query has select count(1), sum(b) from c >> > then we keep getting the error mentioned above as count ends up being >> > bigint and sum ends being double and it is read as float-optional for >> large >> > numbers >> > >> > On Wed, Dec 5, 2018 at 4:16 PM Nitin Pawar <nitinpawar...@gmail.com> >> > wrote: >> > >> > > Hi, >> > > >> > > We have a multistep workflow system and in one of the step we do >> sum(x) >> > > this step results the column being float-optional for next queries and >> > > then functions start failing if the value is large float number (more >> > than >> > > 8 digits) >> > > >> > > Is there any setting where we can change this or it needs to be fixed >> in >> > > code? >> > > error we are getting is >> > > >> > > Error: SYSTEM ERROR: SchemaChangeException: Failure while >> materializing >> > > expression. >> > > Error in expression at index -1. Error: Missing function >> implementation: >> > > [covar_samp(BIGINT-REQUIRED, FLOAT8-OPTIONAL)]. Full expression: >> > --UNKNOWN >> > > EXPRESSION--. >> > > >> > > >> > > >> > > >> > > -- >> > > Nitin Pawar >> > > >> > >> > >> > -- >> > Nitin Pawar >> > >> >> >> -- >> Sincerely, Anton Gozhiy >> anton5...@gmail.com >> > > > -- > Nitin Pawar > -- Sincerely, Anton Gozhiy anton5...@gmail.com