SQL
Fixed the code-generation of the decimal typeCompute Cluster
Fixed a bug that would cause the Compute cluster, in rare cases, not
to update against the configuration.Monitoring
Fixed a bug that would not expose reporting tags to external monitors.API
Fixed a bug that prevented the rolling of clusters.API
Fixed a race condition that prevented multiple concurrent requests to
work and returned Forbidden (403).Snowflake Output
Fixed a bug when writing values to DATE columns.CDC
Fixed a bug that failed to write data which was larger than 2GB.Functions
Added the PRESTO_ZIP functionPython
Allow using URLLIBCDC
Improved the binlog delay monitorAWS VPC integration
Validated subnet ids in Existing AWS VPC integrationAthena Output
Non-string partition columns now supportedSPLIT_DELIMITER_FIRST & PRESTO_SPLIT
ARRAY_JOIN & PRESTO_CONCAT
DATE_DIFF_PRECISE & PRESTO_DATE_DIFF
SHA512
and SHA3_512
functionsSELECT *
on External Hive Metastore when querying with PrestoDB and SparkSQLSELECT *
SELECT *
in Hive Metastore Outputs, this will update the table definition every time a new field arrivespartitions-delay
- The delay between now and the last partition timedata-loading-delay
- The delay on loading data to the metastorepartitions-count
- Number of partitions in the table[]
in array namespacesTO_DATE
: Changed threshold to not return negative dates year
, month
, day
, and hour
are now reserved XX_HASH
and SORT_BY
calculated functions index_type
argument, using _doc
/ doc
by default JSON_TO_RECORD
calculated functinon: Allow whitespace in CSV mapping definition and improve exception handling AND
, OR
, NOT
, and IS DISTINCT FROM
now works like in SQL TO_DATE
calculated function (converts strings to dates without having to insert format) APPROX_COUNT_DISTINCT_EACH
aggregation null:string
) EXTRACT
, MILLISECOND
, SECOND
, MINUTE
, HOUR
, DAY
, DAY_OF_MONTH
, DAY_OF_WEEK
, DAY_OF_YEAR
, WEEK
, MONTH
, QUARTER
, YEAR
, and YEAR_OF_WEEK
date extraction calculated functions REPLACE
calculated function could throw errors in some cases RPAD
, LPAD
, STRPOS
, DATE_ADD
, and DATE_DIFF
calculated functions r5
instead of r4
instances in AWS by default DATE_TRUNC
calculated function --
(see example below)JOIN
GROUP BY
HAVING