Release 340 (8 Aug 2020)#

General#

  • Add support for query parameters in LIMIT, OFFSET and FETCH FIRST clauses. (#4529, #4601)

  • Add experimental support for recursive queries. (#4250)

  • Add bitwise_left_shift(), bitwise_right_shift() and bitwise_right_shift_arithmetic(). (#740)

  • Add luhn_check(). (#4011)

  • Add IF EXISTS and IF NOT EXISTS syntax to ALTER TABLE. (#4651)

  • Include remote host in error info for page transport errors. (#4511)

  • Improve minimum latency for dynamic partition pruning. (#4388)

  • Reduce cluster load by cancelling query stages from which data is no longer required. (#4290)

  • Reduce query memory usage by improving retained size estimation for VARCHAR and CHAR types. (#4123)

  • Improve query performance for queries containing starts_with(). (#4669)

  • Improve performance of queries that use DECIMAL data type. (#4730)

  • Fix failure when GROUP BY clause contains duplicate expressions. (#4609)

  • Fix potential hang during query planning (#4635).

Security#

  • Fix unprivileged access to table’s schema via CREATE TABLE LIKE. (#4472)

JDBC driver#

  • Fix handling of dates before 1582-10-15. (#4563)

  • Fix handling of timestamps before 1900-01-01. (#4563)

Elasticsearch connector#

  • Fix failure when index mapping is missing. (#4535)

Hive connector#

  • Allow creating a table with external_location when schema’s location is not valid. (#4069)

  • Add read support for tables that were created as non-transactional and converted to be transactional later. (#2293)

  • Allow creation of transactional tables. Note that writing to transactional tables is not yet supported. (#4516)

  • Add hive.metastore.glue.max-error-retries configuration property for the number of retries performed when accessing the Glue metastore. (#4611)

  • Support using Java KeyStore files for Thrift metastore TLS configuration. (#4432)

  • Expose hit rate statistics for Hive metastore cache via JMX. (#4458)

  • Improve performance when querying a table with large files and with skip.header.line.count property set to 1. (#4513)

  • Improve performance of reading JSON tables. (#4705)

  • Fix query failure when S3 data location contains a _$folder$ marker object. (#4552)

  • Fix failure when referencing nested fields of a ROW type when table and partition metadata differs. (#3967)

Kafka connector#

  • Add insert support for Raw data format. (#4417)

  • Add insert support for JSON. (#4477)

  • Remove unused kafka.connect-timeout configuration properties. (#4664)

MongoDB connector#

  • Add mongodb.max-connection-idle-time properties to limit the maximum idle time of a pooled connection. (#4483)

Phoenix connector#

  • Add table level property to specify data block encoding when creating tables. (#4617)

  • Fix query failure when listing schemas. (#4560)

PostgreSQL connector#

  • Push down count() aggregations over constant expressions. For example, SELECT count(1). (#4362)

SPI#

  • Expose information about query type in query Event Listener. (#4592)

  • Add support for TopN pushdown via the ConnectorMetadata.applyLimit() method. (#4249)

  • Deprecate the older variants of ConnectorSplitManager.getSplits(). (#4508)