How to activate disk spill on presto?

Member

by orpha , in category: MySQL , 4 months ago

How to activate disk spill on presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by wilmer.lemke , 4 months 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.

Related Threads:

How to add files to disk on laravel?
How to activate jquery features inside an iframe?
How to group time column into 5 second intervals and count rows using presto?
How to get latest 3 months records in presto sql?
How to deduplicate in presto?
How to configure presto?