Release 319 (22 Sep 2019)#
General#
- Fix planning failure for queries involving - UNIONand- DISTINCTaggregates. (#1510)
- Fix excessive runtime when parsing expressions involving - CASE. (#1407)
- Fix fragment output size in - EXPLAIN ANALYZEoutput. (#1345)
- Fix a rare failure when running - EXPLAIN ANALYZEon a query containing window functions. (#1401)
- Fix failure when querying - /v1/resourceGroupStateendpoint for non-existing resource group. (#1368)
- Fix incorrect results when reading - information_schema.table_privilegeswith an equality predicate on- table_namebut without a predicate on- table_schema. (#1534)
- Fix planning failure due to coercion handling for correlated subqueries. (#1453) 
- Improve performance of queries against - information_schematables. (#1329)
- Improve performance of certain queries involving coercions and complex expressions in - JOINconditions. (#1390)
- Include cost estimates in output of - EXPLAIN (TYPE IO). (#806)
- Improve support for correlated subqueries involving - ORDER BYor- LIMIT. (#1415)
- Improve performance of certain - JOINqueries when automatic join ordering is enabled. (#1431)
- Allow setting the default session catalog and schema via the - sql.default-catalogand- sql.default-schemaconfiguration properties. (#1524)
- Add support for - IGNORE NULLSfor window functions. (#1244)
- Add support for - INNERand- OUTERjoins involving- UNNEST. (#1522)
- Rename - legacyand- flatscheduler policies to- uniformand- topologyrespectively. These can be configured via the- node-scheduler.policyconfiguration property. (#10491)
- Add - filenetwork topology provider which can be configured via the- node-scheduler.network-topology.typeconfiguration property. (#1500)
- Add support for - SphericalGeographyto- ST_Length(). (#1551)
Security#
- Allow configuring read-only access in System access control. (#1153) 
- Add missing checks for schema create, rename, and drop in file-based - SystemAccessControl. (#1153)
- Allow authentication over HTTP for forwarded requests containing the - X-Forwarded-Protoheader. This is disabled by default, but can be enabled using the- http-server.authentication.allow-forwarded-httpsconfiguration property. (#1442)
Web UI#
CLI#
- Add - --insecureoption to skip validation of server certificates for debugging. (#1484)
Hive connector#
- Fix reading from - information_schema, as well as- SHOW SCHEMAS,- SHOW TABLES, and- SHOW COLUMNSwhen connecting to a Hive 3.x metastore that contains an- information_schemaschema. (#1192)
- Improve performance when reading data from GCS. (#1443) 
- Allow accessing tables in Glue metastore that do not have a table type. (#1343) 
- Add support for Azure Data Lake ( - adl) file system. (#1499)
- Allow using custom S3 file systems by relying on the default Hadoop configuration by specifying - HADOOP_DEFAULTfor the- hive.s3-file-system-typeconfiguration property. (#1397)
- Add support for instance credentials for the Glue metastore via the - hive.metastore.glue.use-instance-credentialsconfiguration property. (#1363)
- Add support for custom credentials providers for the Glue metastore via the - hive.metastore.glue.aws-credentials-providerconfiguration property. (#1363)
- Do not require setting the - hive.metastore-refresh-intervalconfiguration property when enabling metastore caching. (#1473)
- Add - textfile_field_separatorand- textfile_field_separator_escapetable properties to support custom field separators for- TEXTFILEformat tables. (#1439)
- Add - $file_sizeand- $file_modified_timehidden columns. (#1428)
- The - hive.metastore-timeoutconfiguration property is now accepted only when using the Thrift metastore. Previously, it was accepted for other metastore type, but was ignored. (#1346)
- Disallow reads from transactional tables. Previously, reads would appear to work, but would not return any data. (#1218) 
- Disallow writes to transactional tables. Previously, writes would appear to work, but the data would be written incorrectly. (#1218)