Skip to main content

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)