Release date

12 May 2023

Release note

https://github.com/4paradigm/OpenMLDB/releases/tag/v0.8.0

Highlights

• Added an automatic synchronization tool from an online database to offline storage. With this tool, users can achieve automated synchronization between online and offline data sources, eliminating the need for manual synchronization mechanisms in previous versions. For usage instructions, please refer to the product documentation: https://openmldb.ai/docs/en/main/deploy/online_offline_sync.html. We will soon release a technical blog post that provides a detailed overview of this technology's architecture and use cases.
• Added support for Kubernetes as a backend for the offline engine. In previous versions, only running offline tasks on Yarn clusters was supported. However, based on user feedback, the team introduced support for running the offline engine on Kubernetes clusters in this version. For usage instructions, please refer to the product documentation: https://openmldb.ai/docs/en/main/deploy/offline_integrate_kubernetes.html.
• Added support for Amazon S3 as an offline data source. To better support users who utilize Amazon S3 cloud storage, this version includes integration with Amazon S3 support. For usage instructions, please refer to the product documentation: https://openmldb.ai/docs/en/v0.8/integration/offline_data_sources/s3.html.
• Other significant improvements include:
  • Addition of a series of new computational functions, including var_samp, var_pop, entropy, earth_distance, nth_value_where, and add_months.
  • Support for using LAST JOIN with WHERE and WINDOW UNION clauses.
  • Enhancement of the round function to support an optional second parameter for specifying the number of decimal places to return.
  • SQL deployment now supports a new parameter, SKIP_INDEX_CHECK, which can be used to specify ignoring index type validation (in certain special scenarios).
  • Enhancement of the desc $table command results display can now show information for symbolic links.
  • Several important bug fixes.