Flink SQL computing TOP count attributes

2019-02-11 Thread Ramya Ramamurthy
Hi, I am making use of Flink SQL for processing my data. And I would like to compute TOP counts, for many of the parameters in a row. Is there any better way to do this as i can see that LIMIT is not supported in Batch Queries. Any help is appreciated. Thanks,

Re: Flink SQL computing TOP count attributes

2019-02-18 Thread Fabian Hueske
Hi Ramya, LIMIT is supported for batch SQL but requires an ORDER BY clause to be deterministic. For example SELECT a, b, c FROM Abc ORDER BY a DESC LIMIT 5 is a supported query. If you are only interested in the top-k values (and not the values of the other attributes) you can also implement a