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.05.28-18.43
  • 2023.05.17-13.45
  • 2023.05.15-02.23
  • 2023.05.04-07.39
  1. RELEASE NOTES
  2. Earlier Releases
  3. 2023

May 2023

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

Last updated 11 months ago

Weekly Software Updates

The following software updates were released in May:

2023.05.28-18.43

Bug Fixes

  • CASE WHEN now handles NULL as input and returns the ELSE 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

  • Validate that the first parameter in an is not a literal.

  • Ingestion wizard now supports Amazon Kinesis source.

Bug Fixes

  • with dependencies between them created the wrong name for the nested column.

  • Fixed target name column value for Snowflake outputs in the table.


2023.05.15-02.23

    • SHOW CREATE JOB "Job name"

    • SHOW CREATE TABLE "Table name"

    • SHOW CREATE MATERIALIZED VIEW "MV name"

    • SHOW CREATE CLUSTER "Cluster name"

  • 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.

  • 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 with RUN_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

  • Support querying all system tables using the syntax: SELECT $*.

  • 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.

New Features

New SQL syntax for is now supported:

Enhancements

Bug Fixes

Fixed a bug where a job reading from does not write data into a table.

Fixed a bug where querying can result in an error.

position now starts from 1 as SUBSTRING (previously started from 0).

Enhancements

Information Schema: added a type_evolution column to the system table. to show all previous types of the column.

Improved statistics in .

Bug Fixes

✨
⬆️
🔧
⬆️
🔧
🔧
⬆️
🔧
SHOW CREATE
COLUMN_TRANSFORMATIONS
system.information_schema.jobs
ARRAY_JOIN
system.information_schema.columns
system.monitoring.jobs
BYTES_SUBSTRING
system.information_schema.columns
Job Status