20.5. Release 0.203-e
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 hive.empty-bucketed-partitions.enabled).
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 hive.empty-bucketed-partitions.enabled).
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 standard.
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 March 2017
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.
20.6. 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.
20.7. 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.
20.8. Release 0.203-e.0.4
Fix timeout issue when getting stats on large number of partitions.
20.9. 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.
20.10. Release 0.203-e.0.6
Fix failures when AWS Glue database, table, or partition is missing properties
20.11. 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)
20.12. Release 0.203-e.0.8
Hive Connector changes
Fix multi-file buckets when Presto does the insert
20.13. Release 0.203-e.0.9
Improve statistics estimation for filter expressions
20.14. Release 0.203-e.0.11
Web UI Changes
Fix kill query button
20.15. Release 0.203-e.0.12
Hive Security changes
Add support for cross-realm Kerberos authentication
20.16. Release 0.203-e.0.14
Hive Security changes
Add support for wire encryption
20.17. Release 0.203-e.0.15
Add support for reading Parquet, ORC and RCFile files from KMS-encrypted Hadoop zone.
20.18. 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.