Materialized Result Table storage mechanism

Can anyone tell me how a result table/materialized result table stores its data? Where does it store (RAM/disk), on Aggregator or Leaf, etc…? Thank you very much in advance.

Result tables are stored in memory. Currently they can’t be spilled to disk.

Can you explain more clearly about the distributed memory storage mechanism of Materialized table? When I create a materialized table using Spark, I see a steady increase in memory across the leaves.