Release 0.200#
General#
- Disable early termination of inner or right joins when the right side has zero rows. This optimization can cause indefinite query hangs for queries that join against a small number of rows. This regression was introduced in 0.199. 
- Fix query execution failure for - bing_tile_coordinates().
- Remove the - log()function. The arguments to the function were in the wrong order according to the SQL standard, resulting in incorrect results when queries were translated to or from other SQL implementations. The equivalent to- log(x, b)is- ln(x) / ln(b). The function can be restored with the- deprecated.legacy-log-functionconfig option.
- Allow including a comment when adding a column to a table with - ALTER TABLE.
- Add - from_ieee754_32()and- from_ieee754_64()functions.
- Add - ST_GeometryType()geospatial function.
Hive#
- Fix reading min/max statistics for columns of - REALtype in partitioned tables.
- Fix failure when reading Parquet files with optimized Parquet reader related with the predicate push down for structural types. Predicates on structural types are now ignored for Parquet files. 
- Fix failure when reading ORC files that contain UTF-8 Bloom filter streams. Such Bloom filters are now ignored. 
MySQL#
- Avoid reading extra rows from MySQL at query completion. This typically affects queries with a - LIMITclause.