Hi,I was surprised that functions like “sums” and “deltas” behavedifferently when called directly on a memory mapped partitioned table.Is this difference to be expected?For example, the query select sums size from tradeswill produce a single running sum if the trades table has already beenloaded into memory, but if it is a memory mapped partitioned table, therunning sum will restart at the beginning of each (daily) partition.Are the functions which exhibit this behavior documented anywhere?Thanks,Leon
What’s worse, even drop (_) behaves this way. :) So if you, let’s say handling edges by dropping and ,ing arbitrary or derived value to the column in select, it will work for one day (part) range and fail with 'length for selects across two or more days (parts). Haven’t seen it’s documented anywhere, learned the hard way to do nested select in such cases.
Cheers,
Oleg