here is the link https://drive.google.com/open?id=1PSJMjIvwNObhGsc9jmD9wPapSPI1jQWb
We have tried with direct fields as well but it keeps failing Basically, we have a query which creates above parquet file and the sequential query which fails, I already provided On Thu, Dec 6, 2018 at 10:09 PM Anton Gozhiy <anton5...@gmail.com> wrote: > 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 > -- Nitin Pawar
