How to activate disk spill on presto?

Member

by orpha , in category: MySQL , 22 days ago

How to activate disk spill on presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by wilmer.lemke , 21 days ago

@orpha 

To activate disk spilling on Presto, you can follow these steps:

  1. Open your Presto configuration file (usually presto/etc/config.properties).
  2. Find the section related to disk spill. It is usually called "query.max-spill-per-node" or something similar.
  3. Set the value of this parameter to enable disk spill. This value specifies the maximum amount of memory in bytes that a query is allowed to spill to disk.
  4. Save the configuration file and restart Presto for the changes to take effect.


By following these steps, you should be able to activate disk spill on Presto and allow queries to spill to disk when needed.