I have a index with the follow data: KEY_ID, GROUP, DATE With for example: 1, group1, 2021-06-01 1, group2, 2021-06-02 2, group1, 2021-06-01 ... I want to obtain next date value to show a table like: 1, group1, 2021-06-01,2021-06-02 1, group2, 2021-06-02,NULL ... I know that I can sort It and use a command like streamstats: | streamstats current=f last(DATE) as DATENEXT by KEY_ID But, my issue is that my index have a million of records, so, the results are truncated to 10.000 Is there any way to obtain the DATENEXT without modify limits.conf for streamstats? Thanks a lot¡ Regards
... View more