Table API and AVG on dates

2018-10-30 Thread Flavio Pompermaier
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

2018-10-30 Thread Hequn Cheng
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 wrote: > Hi to all, > I'm using Flink 1.6.1 and it seems that ave

Re: Table API and AVG on dates

2018-10-31 Thread Flavio Pompermaier
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 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 usin