The Apache IoTDB team is pleased to announce the release of Apache IoTDB 2.0.5.
Apache IoTDB (Database for Internet of Things) is an IoT native database with high performance for data management and analysis, deployable on the edge and the cloud. ## Features & Improvements - Data Query: Support manual creation of tree-to-table views - Data Query: Table model adds window functions - Data Query: Table model adds the aggregate function approx_most_frequent - Data Query: Table model JOIN function expansion, supporting LEFT & RIGHT JOIN, ASOF LEFT JOIN - Data Query: Table model supports row pattern recognition, enabling capture of continuous data for analysis and calculation - Storage Management: Table model adds multiple system tables, such as: VIEWS (table view information), MODELS (model information), etc. - AI Management: AINode adds two built-in models: Timer-XL and Timer-Sundial - AI Management: AINode supports inference functions for tree models and table models - ... ## Bugs - Fixed the issue where the where time > X and time < X in last query was not applied to partitioned table fetching, failing to hit PartitionCache - Fixed the error in aggregate query with order by time + align by device for single device across regions - Fixed the error in aggregate query with order by time + align by device for multiple devices across regions - Data synchronization batching supports sink.batch.max-delay-ms, providing more fine-grained cache time control - Fixed the potential NPE issue when the tablet contains null values during data synchronization with sink format=tsfile - Fixed the incorrect processing result of pipe processor when writing tablets with null values with duplicate timestamps - Fixed the issue of tree model load updating table model schema cache - Fixed the issue where disruptor queue close could not be completed, which might cause the DN stop script to get stuck - Fixed multiple issues of data synchronization in normal scenarios, restart scenarios, and deletion scenarios - Fixed the time formatting issue when exporting table model to csv - ... The full release note is available at: https://dlcdn.apache.org/iotdb/2.0.5/RELEASE_NOTES.md The release is available for download at: http://iotdb.apache.org/Download Maven artifacts for JDBC driver, session SDK can be found at: https://search.maven.org/search?q=3Dg:org.apache.iotdb Pypi artifacts for Python SDK can be found at: https://pypi.org/project/apache-iotdb/ Regards, The Apache IoTDB team