Introduce cost-based plan optimizations.
distributed_joinsession property with
reorder_joinssession property with
Add support for ROLE management including CREATE ROLE, DROP ROLE, GRANT ROLE, REVOKE ROLE, SET ROLE, SHOW CURRENT ROLES, SHOW ROLES and SHOW ROLE GRANTS commands.
Track execution statistics of AddExchanges and PredicatePushdown optimizer rules.
Support prepared statements that are longer than 4K bytes.
Improve performance of correlated subqueries with non-equi correlated predicates when broadcast join is enabled
Improve stats calculation for outer joins and correlated subqueries
Hive connector changes#
Implement ROLE management support.
Allow partitions without files for bucketed tables (via
Allow multiple files per bucket for bucketed tables (via
hive.multi-file-bucketing.enabled). There must be one or more files per bucket. File names must match the Hive naming convention.
Allow reading incompletely bucketed tables with missing files (via
skip.footer.line.countHive table property.
Secured internal cluster communication over HTTPS using Kerberos or LDAP authentication.
Release changes the semantics of the
types to align with the SQL standard. See the following sections for details.
Note: This is still experimental work and subject to subsequent changes.
The new semantics is disabled by default but can be enabled using
deprecated.legacy-timestamp config property
legacy_timestamp session property.
TIMESTAMP semantic changes#
TIMESTAMP type described an instance in time in the Presto
session’s time zone. Now, Presto treats
TIMESTAMP values as a set of the
following fields representing wall time:
YEAR OF ERA
MONTH OF YEAR
DAY OF MONTH
HOUR OF DAY
MINUTE OF HOUR
SECOND OF MINUTE- as decimal with precision 3
For that reason, a
TIMESTAMP value is not linked with the session time zone
in any way until a time zone is needed explicitly, such as when casting to a
TIMESTAMP WITH TIME ZONE or
TIME WITH TIME ZONE. In those cases, the
time zone offset of the session time zone is applied, as specified in the SQL
For various compatibility reasons, when casting from date/time type without a time zone to one with a time zone, a fixed time zone is used as opposed to the named one that may be set for the session.
-Duser.timezone="Asia/Kathmandu" on CLI
SELECT CAST(TIMESTAMP '2000-01-01 10:00' AS TIMESTAMP WITH TIME ZONE);
2000-01-01 10:00:00.000 Asia/Kathmandu
2000-01-01 10:00:00.000 +05:45
TIME semantic changes#
TIME type was changed similarly to the
TIME WITH TIME ZONE semantic changes#
Due to compatibility requirements, having
TIME WITH TIME ZONE completely
aligned with the SQL standard was not possible yet. For that reason, when
calculating the time zone offset for
TIME WITH TIME ZONE, the Starburst
distribution of Presto uses the session’s start date and time.
This can be seen in queries using
TIME WITH TIME ZONE in a time zone that
has had time zone policy changes or uses DST. eg. with session start time on 1
SELECT TIME '10:00:00 Asia/Kathmandu' AT TIME ZONE 'UTC'
Time-related bug fixes#
localtimefunctions were fixed to return the correct value for non-UTC timezones.
Update 2 - release 0.203-e.0.2#
Improve data size estimation heuristics to account for auxiliary structures overhead.
Fix average row size computation to account for non-null rows only.
Optimize checking the table privileges.
Update 3 - release 0.203-e.0.3#
Fix execution failure for certain queries containing a join followed by an aggregation when
Fix backward-compatibility processing for array with one group field.
Update 4 - release 0.203-e.0.4#
Fix timeout issue when getting stats on large number of partitions.
Update 5 - release 0.203-e.0.5#
Improve performance of SHOW GRANTS query.
Fix varchar handling in Parquet predicate pushdown
Fix for legacy resource group configuration manager that were unable to run more than a single query that used memory concurrently
Fix bug with inconsistent results in SHOW GRANTS when
adminrole is set.
Update 6 - release 0.203-e.0.6#
Fix failures when AWS Glue database, table, or partition is missing properties
Update 7 - release 0.203-e.0.7#
Allow for predicate pushdown of
Add support for Azure Blob Storage
Add support for Azure Azure Data Lake Storage (ADLS)
Update 8 - release 0.203-e.0.8#
Hive connector changes#
Fix multi-file buckets when Presto does the insert
Update 9 - release 0.203-e.0.9#
Improve statistics estimation for filter expressions
Update 11 - release 0.203-e.0.11#
Web UI changes#
Fix kill query button
Update 12 - release 0.203-e.0.12#
Hive security changes#
Add support for cross-realm Kerberos authentication
Update 14 - release 0.203-e.0.14#
Hive security changes#
Add support for wire encryption
Update 15 - release 0.203-e.0.15#
Add support for reading Parquet, ORC and RCFile files from KMS-encrypted Hadoop zone.
Update 16 - release 0.203-e.0.16#
Add support for creating Avro Hive tables with schema set using the
Support for backward compatible Avro schema evolution.