LogoLogo
OverviewQuickstartsHow To GuidesReferenceArticlesSupport
Overview
Overview
  • Welcome to Upsolver
  • GET STARTED
    • What is Upsolver?
    • Schedule a Demo
    • Start Your Free Trial
    • Apache Iceberg
  • RESOURCES
    • Reference
    • Iceberg Academy
    • Blog
    • Chill Data Summit
    • Community
    • Videos
  • RELEASE NOTES
    • March 2025
    • February 2025
    • January 2025
    • Earlier Releases
      • 2024
        • December 2024
        • November 2024
        • October 2024
        • September 2024
        • August 2024
        • July 2024
        • June 2024
        • May 2024
        • April 2024
        • March 2024
        • February 2024
        • January 2024
      • 2023
        • December 2023
        • November 2023
          • Deprecated Job Option
        • October 2023
        • September 2023
        • August 2023
        • July 2023
        • June 2023
        • May 2023
  • Legal
Powered by GitBook
On this page
  • Weekly Software Updates
  • 2023.08.29-15.15
  • 2023.08.17-13.30
  • 2023.08.16-07.42
  • 2023.08.02-01.57
  1. RELEASE NOTES
  2. Earlier Releases
  3. 2023

August 2023

Upsolver new features, enhancements, and bug fixes for August 2023.

Last updated 11 months ago

Weekly Software Updates

The following software updates were released in August:

2023.08.29-15.15

Enhancements

  • Snowflake: SELECT * will preserve the original case of field names in variant columns.

  • SQL: Allow altering property in tables.

  • Performance Improvement: Reduce the number of file operations when coordinating future table operations.

  • Write Timestamp and Date types as ISO-8601 strings in jobs that write to Elasticsearch.

  • Ingestion wizard: e (Preview).

Bug Fixes

  • Jobs: When using MAP_COLUMNS_BY_NAME, the EXCEPT columns list was fixed to be case-insensitive


2023.08.17-13.30

Enhancements

  • Write Timestamp and Date types as ISO-8601 strings in string output jobs, for example: Job to Elasticsearch, Job to Amazon S3 with format JSON/CSV.

  • Write Timestamp and Date types as ISO-8601 in RECORD_TO_JSON function.

  • Performance improvements in CDC jobs.

  • Performance improvements when querying the Upsolver Query Engine.


2023.08.16-07.42

  • Users can now omit the connection type when specifying a source or target in jobs (e.g. INSERT INTO S3 catalog LOCATION = '...' can be replaced in INSERT INTO catalog LOCATION = '...').

  • Improved the performance of CDC jobs reading from databases with a large number of tables.

  • Querying the information schema tables now returns Jobs and Materialized Views in deleting state.

  • Elasticsearch Jobs:

    • MERGE jobs now support deleting documents by using the WHEN MATCHED AND ... THEN DELETE syntax.

  • Upgraded Avro and Parquet libraries to the latest versions.

  • Major improvements when reading from a table with a large number of partitions.


2023.08.02-01.57

  • CDC Jobs:

  • Elasticsearch Jobs:

    • Support deleting documents with MERGE jobs.

Ingestion wizard: (Preview).

Bug Fixes

Enhancements

Bug Fixes

New Features

(Beta) Support replicating data from .

Enhancements

🔧
⬆️
🔧
✨
⬆️
⬆️
🔧
⬆️
Support CDC from Microsoft SQL Server source
MongoDB
Support CDC from MongoDB sourc
EXPOSE_IN_CATALOG