Let's say that I have a huge clickhouse (database) table (with billions of records). I have a datasource that extracts 50 records from that table, that will be shown in pentaho table component.
Now on button click, I would like to calculate some statistics for these 50 records, but I would like to avoid using new sql queries in order to speed up loading pentaho page.
What I need is access to these 50 records, so I can loop through them, find minimum, maximum, count of certain type of records and so on.
How to access table component record set from button click?