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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> > > 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 > [email protected] > -- Nitin Pawar
