12.39. Release 0.197
General Changes
- Fix query scheduling hang when the
concurrent_lifespans_per_task
session property is set. - Fix failure when a query contains a
TIMESTAMP
literal corresponding to a local time thatdoes not occur in the default time zone of the Presto JVM. For example, if Presto was runningin a CET zone (e.g.,Europe/Brussels
) and the client session was in UTC, an expressionsuch asTIMESTAMP '2017-03-26 02:10:00'
would cause a failure. - Extend predicate inference and pushdown for queries using a
<symbol> IN <subquery>
predicate. - Support predicate pushdown for the
<column> IN <values list>
predicatewhere values in thevalues list
require casting to match the type ofcolumn
. - Optimize
min()
andmax()
to avoid unnecessary object creation in order to reduce GC overhead. - Optimize the performance of
ST_XMin()
,ST_XMax()
,ST_YMin()
, andST_YMax()
. - Add
DATE
variant forsequence()
function. - Add
ST_IsSimple()
geospatial function. - Add support for broadcast spatial joins.
Resource Groups Changes
- Change configuration check for weights in resource group policy to validate thateither all of the subgroups or none of the subgroups have a scheduling weight configured.
- Add support for named variables in source and user regular expressions that can beused to parameterize resource group names.
- Add support for optional fields in DB resource group exact match selectors.
Hive Changes
- Fix reading of Hive partition statistics with unset fields. Previously, unset fieldswere incorrectly interpreted as having a value of zero.
- Fix integer overflow when writing a single file greater than 2GB with optimized ORC writer.
- Fix system memory accounting to include stripe statistics size andwriter validation size for the optimized ORC writer.
- Dynamically allocate the compression buffer for the optimized ORC writerto avoid unnecessary memory allocation. Add config property
hive.orc.writer.max-compression-buffer-size
to limit the maximum size of the buffer. - Add session property
orc_optimized_writer_max_stripe_size
to tune themaximum stipe size for the optimized ORC writer. - Add session property
orc_string_statistics_limit
to drop the stringstatistics when writing ORC files if they exceed the limit. - Use the view owner returned from the metastore at the time of the query rather thanalways using the user who created the view. This allows changing the owner of a view.
CLI Changes
- Fix hang when CLI fails to communicate with Presto server.
SPI Changes
- Include connector session properties for the connector metadata calls madewhen running
SHOW
statements or queryinginformation_schema
. - Add count and time of full GC that occurred while query was running to
QueryCompletedEvent
. - Change the
ResourceGroupManager
interface to include amatch()
method andremove thegetSelectors()
method and theResourceGroupSelector
interface. - Rename the existing
SelectionContext
class to beSelectionCriteria
andcreate a newSelectionContext
class that is returned from thematch()
methodand contains the resource group ID and a manager-defined context field. - Use the view owner from
ConnectorViewDefinition
when present.