Release 0.179

General Changes

  • Fix issue which could cause incorrect results when processing dictionary encoded data. If the expression can fail on bad input, the results from filtered-out rows containing bad input may be included in the query output (#8262).

  • Fix planning failure when similar expressions appear in the ORDER BY clause of a query that contains ORDER BY and LIMIT.

  • Fix planning failure when GROUPING() is used with the legacy_order_by session property set to true.

  • Fix parsing failure when NFD, NFC, NFKD or NFKC are used as identifiers.

  • Fix a memory leak on the coordinator that manifests itself with canceled queries.

  • Fix excessive GC overhead caused by captured lambda expressions.

  • Reduce the memory usage of map/array aggregation functions.

  • Redact sensitive config property values in the server log.

  • Update timezone database to version 2017b.

  • Add repeat() function.

  • Add crc32() function.

  • Add file based global security, which can be configured with the etc/access-control.properties and security.config-file config properties. See Built-in System Access Control for more details.

  • Add support for configuring query runtime and queueing time limits to resource groups.

Hive Changes

  • Fail queries that access encrypted S3 objects that do not have their unencrypted content lengths set in their metadata.

JDBC Driver Changes

  • Add support for setting query timeout through Statement.setQueryTimeout().

SPI Changes

  • Add grantee and revokee to GRANT and REVOKE security checks.