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,
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