drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Help for statistic functions
Date Thu, 06 Dec 2018 13:20:37 GMT
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 <nitinpawar432@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message