OpenMLDB v0.8.5 Release: Enhanced Authentication Feature, Comprehensive Security Upgrade
Tags: machinelearning, opensource, apacheiceberg, tooling
Published: 2024-02-29 07:37:16


## Release Date

28 February 2024

## Release Notes

[https://github.com/4paradigm/OpenMLDB/releases/tag/v0.8.5](https://github.com/4paradigm/OpenMLDB/releases/tag/v0.8.5)

OpenMLDB released a new version v0.8.5, including SQL syntax extensions, Iceberg data lake support, TTL type extensions, and improved user authentication functionality. The most noteworthy feature is the integration of the Iceberg engine and the enhancement of user authentication.

![](https://cdn-images-1.medium.com/max/2800/0*EPSO-1u5BuGYR_t-)

Iceberg is an open-source table format data lake management tool, focusing on providing a highly reliable, scalable data lake management solution. Its core features include atomic write mechanisms, multi-version data management, metadata management, etc., aiming to provide comprehensive data lake management functionality for enterprises. OpenMLDB integrates Iceberg into its platform, allowing users to directly read and write Iceberg data lakes while using OpenMLDB’s features. This results in higher data reliability and consistency, more flexible data operations and management, and more efficient data query performance, providing enterprises with a comprehensive and reliable data lake management solution.

OpenMLDB has also introduced user authentication functionality, allowing users to more flexibly manage and control database access permissions through SQL statements such as `CREATE / ALTER / DROP USER`. This feature not only ensures the security of the data but also enhances the convenience and flexibility of database management. Users can autonomously manage the creation, modification, and deletion of user accounts according to their actual needs, better meeting the enterprise's requirements for data access permission management, and improving the overall system's security and manageability.

For detailed release notes, please refer to: [https://github.com/4paradigm/OpenMLDB/releases/tag/v0.8.5](https://github.com/4paradigm/OpenMLDB/releases/tag/v0.8.5)

Please feel free to download and explore the latest release. Your feedback is highly valued and appreciated. We encourage you to share your thoughts and suggestions to help us improve and enhance the platform. Thank you for your support!

## Highlights

* Added integration with Apache Iceberg offline storage engine, supporting data import and feature data export functionalities, further strengthening the integration of OpenMLDB with the ecosystem.

* Added standard SQL syntax `UNION ALL`, expanding `WINDOW UNION` and `LAST JOIN` to achieve multi-table join.

* Support for `SELECT INTO OUTFILE` to configure OpenMLDB online tables, achieving synchronization between online and offline storage.

* In offline mode, `LAST JOIN` and `WINDOW` operations support not specifying `ORDER BY` parameters, making usage more flexible.

* Added user management functionality, enabling user addition, modification, and deletion through standard SQL statements `CREATE / ALTER / DROP USER`.

* Support for configuring Spark task parameters through SDK, providing more flexible offline task resource configuration.

* `INSERT` statement supports configuring server-side memory limits, providing more user-friendly error messages for insertion failures.

* `LEFT JOIN` statement deployment supports automatic index creation, eliminating the need for manual index creation and data re-importation.

* File storage engine supports TTL types `absandlat / absorlat`, aligning with in-memory storage engine functionality.

------------------------------------------------------------------

For more information on OpenMLDB:
- Website: https://openmldb.ai/
- GitHub: https://github.com/4paradigm/OpenMLDB
- Documentation: https://openmldb.ai/docs/en/
- Join us on [Slack](https://join.slack.com/t/openmldb/shared_invite/zt-ozu3llie-K~hn9Ss1GZcFW2~K_L5sMg) !

> _This post is a re-post from [OpenMLDB Blogs](https://openmldb.medium.com/)._