Re: Help on the Split Distinct Aggregation from Table API

2020-12-10 Thread Felipe Gutierrez
I just realized that i have to use the dayOfTheYear on the gropuBy. I will test again. On Thu, 10 Dec 2020, 18:48 Felipe Gutierrez, wrote: > Hi, > > I am trying to understand and simulate the "Split Distinct > Aggregation" [1] from Table API. I am executing the query: > > SELECT driverId, COUNT

Help on the Split Distinct Aggregation from Table API

2020-12-10 Thread Felipe Gutierrez
Hi, I am trying to understand and simulate the "Split Distinct Aggregation" [1] from Table API. I am executing the query: SELECT driverId, COUNT(DISTINCT dayOfTheYear) FROM TaxiRide GROUP BY driverId on the TaxiRide data from Flink exercises. As it is mentioned in the link [1], the optimization