This topic describes the release notes for Hologres and provides links to the relevant references.

V1.1 (October 2021)

In Hologres V1.1, the following features are added or updated:
  • Features related to O&M
    • Supports the isolation of computing resources within a Hologres instance by using resource groups. This feature is in public preview. You can create multiple resource groups and bind users to different resource groups to isolate computing resources at the thread level within a Hologres instance. This feature applies to the scenarios that involve multiple users or different business requirements. For more information, see Isolate computing resources in a Hologres instance (Beta).
    • Supports online hot upgrades of Hologres instances. A hot upgrade allows you to read data during the upgrade process. You can submit a ticket to perform a hot upgrade on your instance.
  • Features related to engines
    • Supports a storage model that is both row-oriented and column-oriented. You can perform both point queries and online analytical processing (OLAP) on a table that uses this storage model. For more information, see CREATE TABLE.
    • Supports the consumption of Hologres binary logs by using Java Database Connectivity (JDBC). This feature is in public preview. For more information, see Use JDBC to consume Hologres binary logs (Beta).
    • Allows you to enable binary logging and modify the relevant configurations as needed. For more information, see Subscribe to Hologres binlogs.
    • Allows you to rename a table column. For more information, see ALTER TABLE.
    • Supports indexes on fields of the JSONB type. This feature is in public preview. You can create indexes to accelerate queries and retrieval of JSON data. For more information, see JSON and JSONB data types.
    • Optimizes the management mechanism for metadata in Hologres instances. You can cache and compress metadata to implement more effective memory management.
  • Features related to foreign tables
    • Allows you to export data from Hologres to Object Storage Service (OSS). This further reduces the storage cost. For more information, see Use DLF to read OSS data.
    • Supports data queries across Hologres databases and federated queries across Hologres instances. For more information, see Query data across databases.
  • Features related to security management
    • Supports storage encryption for data in Hologres tables and enhances the security in terms of data access. This feature is in public preview. For more information, see Encrypt data in Hologres.
    • Allows you to read encrypted data from MaxCompute. This feature enables Hologres to be further integrated with MaxCompute and is in public preview. For more information, see Query MaxCompute data encrypted based on BYOK.
  • Behavior changes
    • The auto-analyze feature is enabled by default in Hologres V1.1.
    • The new engine for accelerated access to MaxCompute is enabled by default in Hologres V1.1.
    • The resharding feature has been proven to be usable in public preview. The name of the relevant function is changed.
    For more information about behavior changes, see Default behavior changes.

V0.10 (May 2021)

In Hologres V0.10, the following features are added or updated:
  • Features related to engines
    • Supports automatic collection of table data statistics. Statistics can be automatically collected when data is being written to a table. This generates optimized query plans without the need to execute the ANALYZE statement. For more information, see ANALYZE and auto-analyze.
    • Ensures high reliability of point queries of key-value pairs in milliseconds. This feature is in public preview. You can configure multiple replicas at the shard level, switch among the primary shard and follower shards in milliseconds, and retry a query in milliseconds if the query fails. This greatly improves the reliability of Hologres. For more information, see Shard-level replication for high throughout (Beta).
    • Adds extensions for Roaring bitmaps, and provides native support for the Bitmap data type and relevant functions. For more information, see Roaring bitmap functions.
    • Supports the bit_construct and bit_match functions that can be used for user identification and attribution analysis. The functions allow you to aggregate filter conditions to perform user ID-based filtering in an efficient manner. For more information, see Target user identification functions.
    • Supports the range_retention_count and range_retention_sum functions that allow you to specify a date range for user retention analysis. For more information, see Funnel analysis functions.
    • Supports the resharding feature. Hologres provides a built-in function for resharding that allows you to change the number of shards without the need to create tables and import data again. This simplifies the resharding procedure and provides optimal performance. For more information, see User guide of table groups and shard counts.
    • Uses the AliORC data storage format for column-oriented tables by default. This way, the data compression ratio is raised by about 30% to 50%. For more information, see Update the data storage format of existing column-oriented tables.
  • Features related to queries of foreign tables
    • Adopts a new engine for accelerated access to MaxCompute data. Compared with earlier versions, Hologres V0.10 improves query performance by about 30% to 100%. This feature is in public preview. For more information, see Optimize the performance of querying MaxCompute tables in Hologres.
    • Supports the exec_external_sql function that allows you to execute MaxCompute DDL statements in Hologres. For more information, see Execute MaxCompute SQL statements.
    • Integrates with Data Lake Formation (DLF) to allow you to read OSS data in Hologres. This feature is in public preview. For more information, see Use DLF to read OSS data.
  • Performance optimizations
    • Improved point query performance: The maximum throughput of a row-oriented table is increased by 100%, and the maximum throughput of a column-oriented table is increased by 30%.
    • Optimized SQL operations: The performance of UPDATE and DELETE operations is improved by 30%.
    • Optimized cache for query plans: The amount of time required by the optimizer is reduced.
  • Features related to enterprise-level O&M and security management
    • Provides a query history in which you can view the status of all queries initiated in the last 30 days and locate slow queries and failed queries with efficiency. For more information, see Query and analyze slow query logs.

V0.9 (January 2021)

In Hologres V0.9, the following features are added or updated:
  • Features related to engines
    • Supports a wide range of data types.
      • JSON and JSONB. For more information, see JSON and JSONB data types.
      • Time: INTERVAL, TIMETZ, and TIME.
      • Network: INET.
      • Currency: MONEY.
      • PostgreSQL system: NAME, UUID, and OID.
      • Others: BYTEA, BIT, and VARBIT.
      For more information, see Data types.
    • Supports a wide range of functions, including extension functions and PostgreSQL functions.
    • Supports the export of data from Hologres to MaxCompute by using SQL statements. This facilitates data archiving. For more information, see Export data to MaxCompute by executing SQL statements.
    • Supports subscription to Hologres binary logs. This feature is in public preview. For more information, see Subscribe to Hologres binlogs.
    • Allows you to dynamically modify the bitmap index and dictionary encoding properties of a field and automatically determines whether to enable dictionary encoding for a field based on the field value characteristics. For more information, see ALTER TABLE.
    • Releases Hologres Client Library (Holo Client for short). Holo Client allows you to write large amounts of data at a time and perform point queries that support a high volume of queries per second (QPS). For example, you can use Holo Client to synchronize data to Hologres in real time or in batch mode. Holo Client automatically batch collects data to improve the throughput. For more information, see Read and write data by using Holo Client.
    • Optimizes the query optimizer and the JDBC link that is used to write data to Hologres. The efficiency of data writing is improved.
    • Allows you to connect to more business intelligence (BI) tools, such as Tableau Server and Apache Superset. This can meet the requirements for various types of business analysis.
  • Features related to security management
    • Allows enterprise users to access Hologres by using role-based single sign-on (SSO) that is backed by Security Token Service (STS). Role-based SSO is a more secure logon method that helps protect your Alibaba Cloud account. For more information, see RAM authorization mode.

V0.8 (October 2020)

In Hologres V0.8, the following features are added or updated:
  • Features related to engines
    • Supports the CREATE VIEW statement. You can execute this statement to create a view based on one or more Hologres tables or foreign tables, or an existing view. For more information, see VIEW.
    • Supports the SERIAL, DATE, TIMESTAMP, VARCHAR(n), and CHAR(n) data types. Hologres also supports the mapping of arrays between MaxCompute and Hologres when you create a foreign table. For more information, see Data types.
    • Supports the INSERT ON CONFLICT statement. This statement allows you to specify the policy that is used to deal with conflicts when you insert a row that contains the same primary key value as an existing row. For more information, see INSERT ON CONFLICT.
    • Supports the TRUNCATE statement.
    • Supports the Proxima framework that is developed by Alibaba DAMO Academy. Proxima allows you to query a large number of vectors at a time. Proxima is in public preview. For more information, see Vector processing based on Proxima.
  • Features related to security management
    • Provides the sensitive data masking feature. You can configure custom masking policies by using functions to mask your sensitive data, such as phone numbers, addresses, and resident identity card numbers. For more information, see Data masking (Beta).
    • Integrates with CloudMonitor. You can configure custom metrics and alert rules on Hologres by using CloudMonitor.
  • Queries of MaxCompute tables
    • Scans a maximum of 512 partitions during a single query. In versions earlier than V0.8, Hologres scans a maximum of 50 partitions during a single query.
    • Scans a maximum of 200 GB data during a single query, regardless of the numbers of foreign tables and fields. In versions earlier than V0.8, Hologres scans a maximum of 100 GB data during a single query.
    For more information, see Limits.