You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@flink.apache.org by Flavio Pompermaier <po...@okkam.it> on 2018/10/30 17:50:57 UTC

Table API and AVG on dates

Hi to all,
I'm using Flink 1.6.1 and it seems that average on dates is not
supported..am I right?
Is there any effort in implementing it?

Best,
Flavio

Re: Table API and AVG on dates

Posted by Flavio Pompermaier <po...@okkam.it>.

I've opened a ticket for this:
https://issues.apache.org/jira/browse/FLINK-10731

On Wed, Oct 31, 2018 at 7:41 AM Hequn Cheng <ch...@gmail.com> wrote:

> Hi Flavio,
>
> You are right. Avg on dates is not supported. It requires numeric types.
> As a workaround, you can transform the datetime into a numeric type using
> an udf.
>
> Best, Hequn
>
> On Wed, Oct 31, 2018 at 1:51 AM Flavio Pompermaier <po...@okkam.it>
> wrote:
>
>> Hi to all,
>> I'm using Flink 1.6.1 and it seems that average on dates is not
>> supported..am I right?
>> Is there any effort in implementing it?
>>
>> Best,
>> Flavio
>>
>

Re: Table API and AVG on dates

Posted by Hequn Cheng <ch...@gmail.com>.

Hi Flavio,

You are right. Avg on dates is not supported. It requires numeric types.
As a workaround, you can transform the datetime into a numeric type using
an udf.

Best, Hequn

On Wed, Oct 31, 2018 at 1:51 AM Flavio Pompermaier <po...@okkam.it>
wrote:

> Hi to all,
> I'm using Flink 1.6.1 and it seems that average on dates is not
> supported..am I right?
> Is there any effort in implementing it?
>
> Best,
> Flavio
>