Upsolver
Contact Support
  • Welcome to Upsolver
  • Getting Started
    • Start using Upsolver for free
    • Get started as a Upsolver user
      • Upsolver in 5 minutes
        • Upsolver Quickstart in 5 minutes
          • Additional sandbox fun
        • Amazon Athena data output
        • MySQL (AWS RDS) data output
        • Local MySQL data output
      • Upsolver free training
        • Introduction to Upsolver
          • Transform and write data to Amazon Athena
          • Pre-aggregate data for efficiency and performance
          • UPSERT streaming data to Amazon Athena
      • Prerequisites for AWS deployment
      • AWS integration
      • Deploy Upsolver on your AWS account
      • Prerequisites for Azure Deployment
      • Azure Integration
        • Prerequisites for Azure Users
        • Log into Upsolver
        • Log into Azure & Authenticate
        • Set Up and Deploy Azure Resources
        • Delegate Resource Group, and Deploy Upsolver in Azure
        • Integrate Azure with Upsolver
    • Upsolver concepts
      • Deployment models
      • Upsolver components
      • Data ingestion
    • Upsolver Amazon AWS deployment guide
      • Private VPC
      • Upsolver VPC
      • AWS role permissions
      • VPC peering
    • Tutorials and FAQ
      • Tutorials
        • How To Re-process Data
        • Create an Amazon S3 data source
        • Create an Amazon Athena data output
        • Join multiple data streams for real-time analytics
        • Use Upsolver to index less data into Splunk
        • Upsert and delete use case
        • AWS S3 to Athena use case
        • Merge data use case
        • Full vs. Partial Inbound Data Records
      • FAQ
      • Infrastructure
        • What is a dry-run cluster?
    • Glossary
      • Language guide
        • SQL syntax reference
        • Functions
          • Aggregation Functions
            • APPROX_COUNT_DISTINCT
            • APPROX_COUNT_DISTINCT_EACH
            • AVG
            • AVG_EACH
            • AVG_TIME_SERIES
            • COLLECT_SET
            • COLLECT_SET_EACH
            • COUNT
            • COUNT(*)
            • COUNT_DISTINCT
            • COUNT_EACH
            • COUNT_IF
            • DECAYED_SUM
            • DYNAMIC_SESSIONS
            • FIRST
            • FIRST_ARRAY
            • FIRST_EACH
            • FIRST_TIME_SERIES
            • LAST
            • LAST_ARRAY
            • LAST_EACH
            • LAST_K
            • LAST_K_EACH
            • LAST_TIME_SERIES
            • MAX
            • MAX_BY
            • MAX_EACH
            • MAX_TIME_SERIES
            • MIN
            • MIN_BY
            • MIN_EACH
            • MIN_TIME_SERIES
            • SESSION_COUNT
            • STD_DEV
            • STD_DEV_EACH
            • STRING_MAX_EACH
            • STRING_MIN_EACH
            • SUM
            • SUM_EACH
            • SUM_TIME_SERIES
            • WEIGHTED_AVERAGE
          • Calculated functions
            • Aerospike functions
            • Array functions
            • Conditional functions
            • Date functions
            • External API functions
            • Filter functions
            • Numeric functions
            • Spatial functions
            • String functions
            • Structural functions
              • ZIP
            • Type conversion functions
      • Data formats
      • Data types and features
      • Database output options
      • Upsolver shards
      • Permissions list
      • Index
    • Troubleshooting
      • My CloudFormation stack failed to deploy
      • My private API doesn't start or I can't connect to it
        • Elastic IPs limit reached
        • EC2 Spot Instance not running
        • DNS cache
        • Security group not open
      • My compute cluster doesn't start
      • I can't connect to my Kafka cluster
      • I can't create an S3 data source
      • Data doesn't appear in Athena table
      • I get an exception when querying my Athena table
      • Unable to define a JDBC (Postgres) connection
  • Connecting data sources
    • Amazon AWS data sources
      • Amazon S3 data source
        • Quick guide: S3 data source
        • Full guide: S3 data source
      • Amazon Kinesis Stream data source
      • Amazon S3 over SQS data source
      • Amazon AppFlow data source
        • Setup Google Analytics client ID and client secret.
    • Microsoft Azure data sources
      • Azure Blob storage data source
      • Azure Event Hubs data source
    • Kafka data source
    • Google Cloud Storage data source
    • File upload data source
    • CDC data sources (Debezium)
      • MySQL CDC data source
        • Binlog retention in MySQL
      • PostgreSQL CDC database replication
    • JDBC data source
    • HDFS data source
    • Data source UI
    • Data source properties
  • Data outputs and data transformation
    • Data outputs
      • Amazon AWS data outputs
        • Amazon S3 data output
        • Amazon Athena data output
          • Quick guide: Athena data output
          • Full guide: Athena data output
          • Output all data source fields to Amazon Athena
        • Amazon Kinesis data output
        • Amazon Redshift data output
        • Amazon Redshift Spectrum data output
          • Connect Redshift Spectrum to Glue Data Catalog
        • Amazon SageMaker data output
      • Data lake / database data outputs
        • Snowflake data output
          • Upsert data to Snowflake
        • MySQL data output
        • PostgreSQL data output
        • Microsoft SQL Server data output
        • Elasticsearch data output
        • Dremio
        • PrestoDB
      • Upsolver data output
      • HDFS data output
      • Google Storage data output
      • Microsoft Azure Storage data output
      • Qubole data output
      • Lookup table data output
        • Lookup table alias
        • API Playground
        • Serialization of EACH aggregations
      • Kafka data output
    • Data transformation
      • Transform with SQL
        • Mapping data to a desired schema
        • Transforming data with SQL
        • Aggregate streaming data
        • Query hierarchical data
      • Work with Arrays
      • View outputs
      • Create an output
        • Modify an output in SQL
          • Quick guide: SQL data transformation
        • Add calculated fields
        • Add filters
        • Add lookups
          • Add lookups from data sources
          • Add lookups from lookup tables
          • Adding lookups from reference data
        • Output properties
          • General output properties
      • Run an output
      • Edit an output
      • Duplicate an output
      • Stop an output
      • Delete an output
  • Guide for developers
    • Upsolver REST API
      • Create a data source
      • Modify a data source
      • API content formats
    • CI/CD on Upsolver
  • Administration
    • Connections
      • Amazon S3 connection
      • Amazon Kinesis connection
      • Amazon Redshift connection
      • Amazon Athena connection
      • Amazon S3 over SQS connection
      • Google Storage connection
      • Azure Blob storage connection
      • Snowflake connection
      • MySQL connection
      • Elasticsearch connection
      • HDFS connection
      • Qubole connection
      • PostgreSQL connection
      • Microsoft SQL Server connection
      • Spotinst Private VPC connection
      • Kafka connection
    • Clusters
      • Cluster types
        • Compute cluster
        • Query cluster
        • Local API cluster
      • Monitoring clusters
      • Cluster tasks
      • Cluster Elastic IPs
      • Cluster properties
      • Uploading user-provided certificates
    • Python UDF
    • Reference data
    • Workspaces
    • Monitoring
      • Credits
      • Delays In Upsolver pipelines
      • Monitoring reports
        • Monitoring system properties
        • Monitoring metrics
    • Security
      • IAM: Identity and access management
        • Manage users
        • Manage groups
        • Manage policies
      • Git integration
      • Single sign-on with SAML
        • Microsoft Azure AD with SAML sign-on
        • Okta with SAML sign-on
        • OneLogin with SAML sign-on
      • AMI security updates
  • Support
    • Upsolver support portal
  • Change log
  • Legal
Powered by GitBook
On this page
  • 2025.03.13-02.07
  • 2025.02.13-11.24
  • 2025.02.04-13.42
  • 2025.01.13-09.11
  • 2025.01.08-07.52
  • 2024.11.28-08.49
  • 2024.11.14-07.22
  • 2024.11.05-11.18
  • 2024.10.07-11.42
  • 2024.09.26-09.41
  • 2024.09.18-13.03
  • 2024.09.18-09.11
  • 2024.09.10-07.45
  • 2024.09.01-09.29
  • 2024.08.26-09.46
  • 2024.08.19-12.07
  • 2024.08.15-10.03
  • 2024.08.07-11.23
  • 2024.07.30-06.58
  • 2024.07.29-08.06
  • 2024.07.11-12.30
  • 2024.07.08-11.10
  • 2024.06.30-08.33
  • 2024.06.20-15.35
  • 2024.06.10-17.20
  • 2024.06.04-11.16
  • 2024.06.02-15.50
  • 2024.05.28-11.58
  • 2024.05.23-08.45
  • 2024.05.19-13.23
  • 2024.05.12-10.26
  • 2024.05.09-08.33
  • 2024.05.02-15.37
  • 2024.04.25-12.36
  • 2024.04.16-12.06
  • 2024.04.04-09.33
  • 2024.03.27-07.52
  • 2024.03.10-10.52
  • 2024.03.05-11.08
  • 2024.02.25-14.23
  • 2024.02.18-12.36
  • 2024.02.13-09.06
  • 2024.02.08-09.59
  • 2024.01.16-08.45
  • 2024.01.09-14.59
  • 2024.01.02-13.40
  • 2023.12.25-09.02
  • 2023.12.11-01.58
  • 2023.12.06-11.31
  • 2023.11.29-01.59
  • 2023.11.27-01.59
  • 2023.11.21-01.59
  • 2023.11.19-08.51
  • 2023.11.14-13.42
  • 2023.11.07-12.30
  • 2023.10.30-11.38
  • 2023.10.25-08.55
  • 2023.10.17-17.45
  • 2023.10.11-11.26
  • 2023.10.04-10.37
  • 2023.09.13-12.16
  • 2023.09.05-11.12
  • 2023.08.29-15.15
  • 2023.08.17-13.30
  • 2023.08.16-07.42
  • 2023.08.02-01.57
  • 2023.07.31-02.02
  • 2023.07.27-01.59
  • 2023.07.19-02.34
  • 2023.07.13-02.20
  • 2023.07.06-02.18
  • 2023.07.04-14.42
  • 2023.06.26-03.44
  • 2023.06.19-10.37
  • 2023.06.12-08.57
  • 2023.06.05-11.39
  • 2023.05.28-18.43
  • 2023.05.17-13.45
  • 2023.05.15-02.23
  • 2023.05.04-07.39
  • 2023.04.27-07.52
  • 2023.04.18-07.10
  • 2023.03.26-19.27
  • 2023.03.15-10.04
  • 2023.03.09-13.48
  • 2023.02.26-15.40
  • 2023.02.19-15.15
  • 2023.02.12-15.57
  • 2023.02.07-10.02
  • 2023.01.31-15.19
  • 2023.01.22-16.42
  • 2023.01.16-14.02
  • 2023.01.10-20.52
  • 2023.01.03-339
  • 2022
  • 2022.12.29-325
  • 2022.12.18-235
  • 2022.12.15-638
  • 2022.12.05-201
  • 2022.11.29-164
  • 2022.11.17-118
  • 2022.11.09-61
  • 2022/Mar/22
  • 2022/Mar/21
  • 2022/Feb/20
  • 2022/Feb/08 ANNOUNCEMENT
  • 2021
  • 2021/10/05
  • 2021/08/09
  • 2021/08/02
  • 2021/07/19
  • 2021/07/11
  • 2021/07/05
  • 2021/06/28
  • 2021/06/21
  • 2021/06/13
  • 2021/06/07
  • 2021/05/31
  • 2021/05/24
  • 2021/05/12
  • 2021/05/04
  • 2021/05/03
  • 2021/04/18
  • 2021/04/04
  • 2021/03/28
  • 2021/03/21
  • 2021/03/14
  • 2021/03/07
  • 2021/03/01
  • 2021/02/23
  • 2021/01/04
  • 2020
  • 2020/12/08
  • 2020/11/01
  • 2020/10/21
  • 2020/10/15
  • 2020/10/13
  • 2020/10/05
  • 2020/10/01
  • 2020/09/30 - SNAPSHOT
  • 2020/09/23
  • 2020/09/14
  • 2020/09/07
  • 2020/08/31
  • 2020/08/24
  • 2020/08/17
  • 2020/08/10
  • 2020/08/03
  • 2020/07/27
  • 2020/07/20
  • 2020/07/13
  • 2020/07/06
  • 2020/06/29
  • 2020/06/22
  • 2020/06/15
  • 2020/06/08
  • 2020/06/01
  • 2020/05/25
  • 2020/05/18
  • 2020/05/04
  • 2020/04/27
  • 2020/04/20
  • 2020/04/06
  • 2020/03/30
  • 2020/03/16
  • 2020/03/09
  • 2020/02/24
  • 2020/02/18
  • 2020/02/10
  • 2020/02/05
  • 2020/01/30
  • 2020/01/22
  • 2020/01/13
  • 2020/01/06
  • 2019
  • 2019/12/22
  • 2019/12/16
  • 2019/12/09
  • 2019/12/03
  • 2019/11/17
  • 2019/11/10
  • 2019/10/31
  • 2019/09/23
  • 2019/09/02
  • 2019/07/08
  • 2019/06/24
  • 2019/06/17
  • 2019/06/03
  • 2019/05/26
  • 2019/05/19
  • 2019/05/14
  • 2019/05/13
  • 2019/05/06
  • 2019/04/22
  • 2019/04/08
  • 2019/04/01
  • 2018
  • 2018/11/15
  • 2018/11/14
  • 2018/06/26
  • 2018/06/18
  • 2018/06/17
  • 2018/03/01

Was this helpful?

Change log

Change log for Upsolver Classic (app.upsolver.com)

PreviousUpsolver support portalNextLegal

Last updated 1 month ago

Was this helpful?

Release notes for sqlake.upsolver.com may be found .

2025.03.13-02.07

Bug fixes

  • Minor bug fixes

2025.02.13-11.24

Enhancements

  • Upgraded libraries to include recent security patches, enhancing system security and stability

Bug fixes

  • Minor bug fixes

2025.02.04-13.42

Enhancements

  • Functions: Added new function LEAD_IN_ARRAY

  • Upgraded Snowflake driver to 3.16.0

Bug fixes

  • Minor bug fixes

2025.01.13-09.11

Enhancements

  • Support setting custom properties for tables and views in Hive metastore connection

Bug fixes

  • Minor bug fixes

2025.01.08-07.52

Bug fixes

  • Minor bug fixes

2024.11.28-08.49

Bug fixes

  • Minor bug fixes

2024.11.14-07.22

Enhancements

  • Upgraded libraries to include recent security patches, enhancing system security and stability

Bug fixes

  • Minor bug fixes

2024.11.05-11.18

Enhancements

  • Upgraded libraries to include recent security patches, enhancing system security and stability

Bug fixes

  • Minor bug fixes

2024.10.07-11.42

Bug fixes

  • Minor bug fixes

2024.09.26-09.41

Bug fixes

  • Minor bug fixes

2024.09.18-13.03

Bug fixes

  • Minor bug fixes

2024.09.18-09.11

Bug fixes

  • Minor bug fixes

2024.09.10-07.45

Bug fixes

  • Minor bug fixes

2024.09.01-09.29

Bug fixes

  • Minor bug fixes

2024.08.26-09.46

Bug fixes

  • Minor bug fixes

2024.08.19-12.07

Bug Fixes

  • Minor bug fixes

2024.08.15-10.03

Enhancements

  • Use JSON as the intermediate format when writing to Redshift

Bug Fixes

  • Fixed a rare case where some task executions would stop running until the server is restarted

  • Fixed a bug where outputs with more shards than the data source failed to distribute rows across shards when data correction was applied evenly

2024.08.07-11.23

Enhancements

  • Athena Output:

    • Added support for using Field Transforms on columns with an array of primitive types

Bug Fixes

  • Fixes Minor bug fixes

2024.07.30-06.58

Enhancements

  • Reduced overhead of tasks discovery, especially in compute clusters with a lot of assigned entities or with a large number of shards

Bug Fixes

  • Minor bug fixes

2024.07.29-08.06

Enhancements

  • Athena Output:

    • Optimized the coordinator task to prevent long-running processes and avoid delays in the output

  • Performance improvements for high-loaded clusters

Bug Fixes

  • Minor bug fixes

2024.07.11-12.30

Bug Fixes

  • Minor bug fixes

2024.07.08-11.10

Bug Fixes

  • Fixed a bug occurring when the Primary Key is of numeric type and the table is large enough to require chunk splitting

  • Minor bug fixes

2024.06.30-08.33

Enhancements

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

  • Performance improvement: Reduced task scheduling overhead in outputs that read from versioned Upsolver outputs

Bug Fixes

  • Disabled the creation of data corrections in output types that do not support it, such as JDBC Outputs

  • Minor UI bug fixes

2024.06.20-15.35

Enhancements

  • Implemented deletion of temporary intermediate files in Data Sources after their usage. This feature will be enabled gradually.

Bug Fixes

  • Reference Data: When an old version of an output is completed, stop loading the Reference Data file being used in this version. This prevents errors caused by deleted Reference Data files that are no longer used in the latest versions.

2024.06.10-17.20

Enhancements

  • Added support for shards in outputs writing to Elasticsearch

Bug Fixes

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

2024.06.04-11.16

Bug Fixes

  • Fix an issue with SAML that causes Azure to fail to parse the request

2024.06.02-15.50

Bug Fixes

  • Athena Output:

    • Optimized the performance of retention deletion

2024.05.28-11.58

Bug Fixes

  • Fixed an issue where 2-minute merge files were sometimes not properly deleted when deleting Materialized Views

  • Fixed a bug where temporary files wouldn't be deleted in the index creation task when the task failed

  • Minor bug fixes

2024.05.23-08.45

Enhancements

  • Upgraded the Amazon Redshift driver

Bug Fixes

  • Fixed CDC client sometimes becoming temporarily stuck after server replacement

  • Minor bug fixes

2024.05.19-13.23

Enhancements

  • Help widget adjustments (size and location have changed to prevent hiding application data)

Bug Fixes

  • Fixed Snapshotting of tables sometimes being stuck in CDC

  • Fixed a bug causing Amazon S3 outputs to be stuck on retention deletion when the output has multiple versions

  • Minor bug fixes

2024.05.12-10.26

Enhancements

  • Upgraded libraries to include recent security patches to enhance system security and stability

Bug Fixes

  • Minor bug fixes

2024.05.09-08.33

Enhancements

  • Upgraded libraries to include recent security patches to enhance system security and stability

Bug fixes

  • Minor bug fixes

2024.05.02-15.37

Enhancements

  • Libraries upgrade to include security patches

Bug Fixes

  • Minor bug fixes

2024.04.25-12.36

Bug Fixes

  • Run connection validation tasks on servers with elastic ips when elastic ips are enabled

  • MongoDB CDC:

    • Corrected the parsing of Decimal types to Double

    • Resolved errors encountered when replicating collections containing fields with types Regex, Min Key, and Max Key

2024.04.16-12.06

Enhancements

  • Upgraded the Snowflake driver to 3.15.0

Bug Fixes

  • Minor bug fixes

2024.04.04-09.33

Enhancements

  • For new entities, use the updated Parquet list structure (parquet.avro.write-old-list-structure = false) when writing Parquet files to S3 and Upsolver Tables

Bug Fixes

  • Fixed a bug that could skip data when reading from CDC sources

  • Minor bug fixes

2024.03.27-07.52

Bug Fixes

  • Minor bug fixes

2024.03.10-10.52

Bug Fixes

  • Minor bug fixes

2024.03.05-11.08

Enhancements

Bug Fixes

  • Minor bug fixes

2024.02.25-14.23

Bug Fixes

  • Minor bug fixes

2024.02.18-12.36

Bug Fixes

  • Minor bug fixes

2024.02.13-09.06

Bug Fixes

  • Minor bug fixes

  • Please note that in addition to the updates mentioned in this release note, it encompasses all enhancements and changes from previous versions.

2024.02.08-09.59

Bug Fixes

  • Minor bug fixes

2024.01.16-08.45

Enhancements

  • Performance Improvement in Transformations of Outputs / Lookup Tables

  • Allow downloading the outputs list grid as CSV

Bug Fixes

  • Apache Kafka Jobs:

    • Fixed new Kafka ingestion/data sources stalling when reading from the start in certain situations

2024.01.09-14.59

Bug Fixes

  • Minor bug fixes

2024.01.02-13.40

Bug Fixes

  • S3 Data Source: Resolved a race condition that could lead to duplicated ingestion of the same file in scenarios where an S3 data source is used with a date pattern that does not follow lexicographical order

  • Minor Bug Fixes

2023.12.25-09.02

Bug Fixes

  • Minor Bug Fixes

2023.12.11-01.58

Bug Fixes

  • Minor Bug Fixes

2023.12.06-11.31

Enhancements

  • When using Avro Schema Registry content format with Debezium, support parsing JSON type

Bug Fixes

  • Minor bug fixes

2023.11.29-01.59

Bug Fixes

  • Minor bug fixes

2023.11.27-01.59

  • Minor bug fixes

2023.11.21-01.59

Enhancements

  • Added support for r7 instance types in Compute Clusters

Bug Fixes

  • Fixed an issue preventing users from being able to create compute clusters

  • Fixed the replay cluster not being shut down in some situations

2023.11.19-08.51

Enhancements

  • New compactions metrics: Compaction delay, Number of files in WAL

Bug Fixes

  • Minor bug fixes

2023.11.14-13.42

Enhancements

  • S3 With SQS: Limit the size of bulk reads from SQS to ensure data is distributed evenly

Bug Fixes

  • Minor bug fixes

2023.11.07-12.30

Bug Fixes

  • Fixed some rare instances where a broken JDBC Data Source could interfere with other task executions

  • Fixed a bug causing loading of all tasks to fail if a task was created with a start time way in the future

2023.10.30-11.38

Bug Fixes

  • Minor bug fixes

2023.10.25-08.55

Bug Fixes