I have a index with the follow data:
KEY_ID, GROUP, DATE
With for example:1, group1, 2021-06-011, group2, 2021-06-022, group1, 2021-06-01
I want to obtain next date value to show a table like:1, group1, 2021-06-01,2021-06-021, 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¡
Does window=1 help?
| streamstats window=1 current=f last(DATE) as DATENEXT by KEY_ID
View solution in original post