What is the fastest way to get a max value in a group by table?
Hi, I am currently running a data load that looks like this:
max(timestamp) as timestamp
group by second_id;
What this does is it finds only the latest entry by second_id and discards the rest of the entries. However I have tried to load and I know that this is an expensive query. I have seen other options such as `Peek` and `LOAD FieldValue(‘Id’, recno()) as Id AUTOGENERATE FieldValueCount(‘Id’)` and I want to know how to use these in my case.
You can always Order your data before you store it into qvd. Then when you load the data from qvd you can directly use Group by. I guess all these are worth a shot, not sure what exactly will work the best.