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