June 2024

Upsolver new features, enhancements, and bug fixes for June 2024.

Release Notes Blog

For more detailed information on these updates, check out the Upsolver July 2024 Feature Summary blog.

2024.06.30-08.33

⬆️ Enhancements

• Apache Iceberg:

  • Added support for creating Iceberg tables with hidden partitions using partition transforms

  • Added support for setting retention on partitions with type Long/Integer, enabling retention on hidden partitions that use time truncate transformations such as year/month/day/hour

• Amazon S3: Reduced the number of upload file part requests by using larger parts

• Amazon Redshift Targets: Added TRUNCATE_COLUMNS property to truncate VARCHAR or CHARACTER VARYING fields by the target column size when inserting into an existing table

🔧 Bug Fixes

• [BREAKING CHANGE]: Removed $commit_time column from all system tables

• Amazon S3: Fixed cases where incomplete multipart upload files were not cleaned up

• Apache Iceberg: Schema evolution was assumed for new fields with a suffix and type that match other fields

• Minor bug fixes

2024.06.20-15.35

⬆️ Enhancements

• Apache Iceberg:

  • CREATE EXTERNAL ICEBERG TABLE statement:

    • Changed the default value for the OPTIMIZE property to FALSE when creating external Iceberg tables

  • CREATE ICEBERG TABLE statement:

    • Allow the setting Iceberg properties using iceberg.property.name syntax

    • Removed the COLUMN_DATA_RETENTION property when creating Iceberg tables, as this property is only supported in Upsolver Managed Hive tables

• Implemented deletion of temporary intermediate files in ingestion jobs after their usage. This feature will be enabled gradually
• Ingestion wizard:

  • When creating replication (CDC) jobs via the wizard, we have now added the ability to map selected source schemas to target schemas automatically. If target schemas do not already exist, they will be created automatically. The source and target schemas will be identical. This option was previously available only via SQL. In addition, we have improved the experience when configuring source to schema mapping

🔧 Bug Fixes

• Minor bug fixes

2024.06.10-17.20

⬆️ Enhancements

• Query Iceberg Tables - Customers can now query Iceberg tables using Upsolver's Query Engine for preview

• Auto Sharding: Output files can now be split across shards within a partition

• Improved the compaction speed for sorted Iceberg tables

🔧 Bug Fixes

• Fixed a bug that caused jobs writing to Iceberg tables not to produce any rows when the job's source was a system table

• Fixed Iceberg creating dangling files during failed compactions

• CDC Inputs: Implemented deletion of intermediate files that store the metadata of the source database

• Fixed the shard number in system.monitoring.recent_compactions
• External Iceberg Tables: Added support for data retention on external Iceberg tables

---

2024.06.04-11.16

⬆️ Enhancements

• Amazon Redshift outputs now support custom commit interval

🔧 Bug Fixes

• Non-Sync jobs reading from Apache Iceberg with an interval that is larger than 1 minute did not read all data from the source table

• Jobs writing to Hive tables with an interval equal to or larger than 7 days could get stuck unless extra configuration was done by Upsolver support

• Fixed a bug that prevented a job writing to a table with an end time from being marked as Completed when the end time was reached

---

2024.06.02-15.50

✨ New Features

• Iceberg Table Mirrors

  • Create mirrors of your Iceberg tables in Snowflake. Maintains an external Iceberg table in Snowflake that Upsolver keeps up-to-date by pointing to the latest snapshot of the table.

• Data Ingestion Wizard

  • Support direct ingestion to Amazon Redshift

🔧 Bug Fixes

• Minor bug fixes