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.

1 Like

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.