Oct 2, 2018

• Presto 0.205 in Production Prepare for Upgrade
• Side-by-Side Environments
• Migration Timeline
• Running Code in Presto 0.205 vs. Presto 0.188
• Required SQL Changes for Presto 0.205
• New System Function current_user
• Syntax Error-Producing Queries
• Changes in ORDER BY behavior
• JOIN with USING
• Error Message: Given correlated subquery is not supported
• Recommended Update: Replace TD_SESSIONIZE with TD_SESSIONIZE_WINDOW

Presto 0.205 in Production Prepare for Upgrade

Treasure Data’s new Presto release (available 1 October 2018) is based on the open source Presto 0.205 release. Our previous release was based on Presto 0.188.

We have done our own internal testing to identify compatibility and performance regression issues, and we document those below.