Thank you Anton.
I will watch the jira for further progress
On Mon, Dec 10, 2018 at 10:01 PM Anton Gozhiy wrote:
> This is really a bug, reported it here:
> https://issues.apache.org/jira/browse/DRILL-6891.
> Thanks for finding this case.
>
> On Sat, Dec 8, 2018 at 7:15 AM Nitin Pawar
>
This is really a bug, reported it here:
https://issues.apache.org/jira/browse/DRILL-6891.
Thanks for finding this case.
On Sat, Dec 8, 2018 at 7:15 AM Nitin Pawar wrote:
> here is the link
> https://drive.google.com/open?id=1PSJMjIvwNObhGsc9jmD9wPapSPI1jQWb
>
> We have tried with direct fields
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
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
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
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
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
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