Fix a race condition, where if a query was submitted before the resource group configuration had been loaded by the Presto server, all queries to the cluster would fail with a
Fix a bug in the
GatherAndMergeWindowsoptimization would produces invalid plans when the output of a window function was used in the frame definition of another window function.
Fix the output of
NULLNow it will throw exception if the found matched value is NULL.
Fix a bug where duplicate items in
UNNESTwould lead to query compilation failure.
Improve filtering for large tables with
LIMITnumber of keys for queries that do simple
GROUP BY LIMITwith no
ORDER BY. This feature can be enabled with a boolean session param:
remove_nulls()to remove null elements from the given array.
find_first_index()which returns the index of the first element which satisfies the condition.
Add range with offset expression support to Window Functions.
Add the names of the functions invoked by the query to the completed event. This can be enabled with the
log_invoked_function_names_enabledsession property or the
Add a new runtime metric
optimizerTimeNanosto measure the time taken by the optimizers. With this change the time taken by optimizers has been removed from runtime metric
Add support to report both client-side and server-side latency in presto-cli result summary. The client-side latency is the wall time presto-cli spends for the query to finish, and it no longer includes the time spent by the user paging through results. The server side latency represents the wall time the engine uses to finish executing this query.
Add ANSI SQL compliant syntax
FETCH FIRST N ROWS ONLYas an alternative way to express
LIMIT n. For example
select * from table_name FETCH FIRST 3 ROWS ONLYis equivalent to
SELECT * FROM table_name LIMIT 3, and will return only 3 rows as a result of the sql query.
Replace Airlift from version 0.205 to 0.207.
deprecated.legacy-date-timestamp-to-varchar-coercionconfiguration property, which was used for Raptor to Presto migration.
Resource Groups Changes#
Fix blocking resource group lock when query queue is full (
Add Amazon S3 Select pushdown for JSON files.
Aditi Pandit, Ajay George, Amit Dutta, Anant Aneja, Arun Thirupathi, Avinash Jain, Ben Tony Joe, Chunxu Tang, Darren Fu, Deepak Majeti, Ge Gao, Ivan Sadikov, Jalpreet Singh Nanda (:imjalpreet), James Petty, Jingmei Huang, Karteek Murthy Samba Murthy, Konstantinos Karanasos, Linsong Wang, Lisheng, Maria Basmanova, Michael Shang, Miłosz Linkiewicz, Nikhil Collooru, Paul Meng, Pranjal Shankhdhar, Rebecca Schlussel, Rohit Jain, Ruslan Mardugalliamov, Sergey Pershin, Sergii Druzkin, Shrinidhi Joshi, Sreeni Viswanadha, Timothy Meehan, Vladimir Ozerov, Ying, Zac, Zhongjun Jin (Mark), dnnanuti, feilong-liu, singcha, tanjialiang, xiaoxmeng, 枢木