Release 0.193#
General#
- Fix an infinite loop during planning for queries containing non-trivial predicates. 
- Fix - row_number()optimization that causes query failure or incorrect results for queries that constrain the result of- row_number()to be less than one.
- Fix failure during query planning when lambda expressions are used in - UNNESTor- VALUESclauses.
- Fix - Tried to free more revocable memory than is reservederror for queries that have spilling enabled and run in the reserved memory pool.
- Improve the performance of the - ST_Contains()function.
- Add - map_zip_with()lambda function.
- Add - normal_cdf()function.
- Add - SET_DIGESTtype and related functions.
- Add query stat that tracks peak total memory. 
- Improve performance of queries that filter all data from a table up-front (e.g., due to partition pruning). 
- Turn on new local scheduling algorithm by default (see Release 0.181). 
- Remove the - information_schema.__internal_partitions__table.
Security#
- Apply the authentication methods in the order they are listed in the - http-server.authentication.typeconfiguration.
CLI#
- Fix rendering of maps of Bing tiles. 
- Abort the query when the result pager exits. 
JDBC driver#
- Use SSL by default for port 443. 
Hive#
- Allow dropping any column in a table. Previously, dropping columns other than the last one would fail with - ConcurrentModificationException.
- Correctly write files for text format tables that use non-default delimiters. Previously, they were written with the default delimiter. 
- Fix reading data from S3 if the data is in a region other than - us-east-1. Previously, such queries would fail with- "The authorization header is malformed; the region 'us-east-1' is wrong; expecting '<region_name>'", where- <region_name>is the S3 region hosting the bucket that is queried.
- Enable - SHOW PARTITIONS FROM <table> WHERE <condition>to work for tables that have more than- hive.max-partitions-per-scanpartitions as long as the specified- <condition>reduces the number of partitions to below this limit.
Blackhole#
- Do not allow creating tables in a nonexistent schema. 
- Add support for - CREATE SCHEMA.
Memory connector#
- Allow renaming tables across schemas. Previously, the target schema was ignored. 
- Do not allow creating tables in a nonexistent schema. 
MongoDB#
- Add - INSERTsupport. It was previously removed in 0.155.