May 2023
Upsolver new features, enhancements, and bug fixes for May 2023.
Weekly Software Updates
The following software updates were released in May:
2023.05.28-18.43
🔧 Bug Fixes
CASE WHEN
now handlesNULL
as input and returns theELSE
value.CDC: Fixed the bug that caused the ingestion of a decimal type column to be converted to binary base64 string.
2023.05.17-13.45
⬆️ Enhancements
Ingestion wizard now supports Amazon Kinesis source.
🔧 Bug Fixes
2023.05.15-02.23
✨ New Features
SHOW CREATE JOB "Job name"
SHOW CREATE TABLE "Table name"
SHOW CREATE MATERIALIZED VIEW "MV name"
SHOW CREATE CLUSTER "Cluster name"
⬆️ Enhancements
PostgreSQL Jobs:
Support reading 14+ partitioned tables by the root table name instead of the underlying partition table names.
Snowflake Jobs:
Added query tag to queries executed by Upsolver for easier cost tracking.
🔧 Bug Fixes
Fixed the bug where
TABLE_DATA_RETENTION
could be disabled by disabling compactions.Dropping a table while specifying
DELETE_DATA = true
did not delete data files written by jobs withRUN_PARALLELISM > 1
.Parquet files are now distributed more evenly when ingesting data from Amazon S3 with high execution parallelism.
Fixed a bug when selecting from large materialized views with predicates on key columns would return "Query exceeded input row limit".
2023.05.04-07.39
⬆️ Enhancements
Support querying all system tables using the syntax:
SELECT $*
.
🔧 Bug Fixes
Fixed the issue of inviting a member to the organization not working.
Prevented the creation of sync jobs that read from system tables.
Fixed a bug in jobs when writing to Amazon S3 with a dynamic location.
Fixed a bug that caused some columns to be missing when reading from a table.
Last updated