12.56. Release 0.180
- Fix a rare bug where rows containing only values are not returnedto the client. This only occurs when an entire result page contains only
null
values. The only known case is a query over an ORC encoded Hive tablethat does not perform any transformation of the data. - Fix incorrect results when performing comparisons between values of approximatedata types (
REAL
,DOUBLE
) and columns of certain exact numeric types(INTEGER
,BIGINT
,DECIMAL
). - Fix query failure due to
NoClassDefFoundError
when scalar functions declaredin plugins are implemented with instance methods. - Improve performance of map subscript from O(n) to O(1) in all cases. Previously, only mapsproduced by certain functions and readers could take advantage of this improvement.
- Skip unknown costs in
EXPLAIN
output. - Support Secure Internal Communication between Presto nodes.
- Add initial support for
CROSS JOIN
againstLATERAL
derived tables. - Add support for
VARBINARY
concatenation. - Add that makes it possible to use Presto withexternal systems without the need to implement a custom connector.
- Add experimental REST endpoint on coordinator.
Hive Changes
- Ignore partition bucketing if table is not bucketed. This allows droppingthe bucketing from table metadata but leaving it for old partitions.
- Improve error message for Hive partitions dropped during execution.
- The optimized RCFile writer is enabled by default, but can be disabledwith the
hive.rcfile-optimized-writer.enabled
config option.The writer supports validation which reads back the entire file afterwriting. Validation is disabled by default, but can be enabled with thehive.rcfile.writer.validate
config option.
- Add support for
INSERT
. - Add support for pushdown of non-equality predicates on clustering keys.
JDBC Driver Changes
- Add support for authenticating using Kerberos.
- Allow configuring SSL/TLS and Kerberos properties on a per-connection basis.
- Add support for executing queries using a SOCKS or HTTP proxy.
SPI Changes
- Add running time limit and queued time limit to
ResourceGroupInfo
.