All Products
Search
Document Center

Hologres:Limits

Last Updated:Aug 12, 2024

This topic describes the limits of Hologres.

Limits on data queries in MaxCompute tables

  • Hologres can scan up to 512 partitions from a partitioned table during a single query.

  • The maximum amount of underlying data that can be scanned for each query is 200 GB, regardless of the number of tables and fields.

  • Hologres does not support the built-in functions of MaxCompute.

Limits on UDFs

  • Hologres does not support user-defined functions (UDFs) that are created in MaxCompute.

  • Hologres does not allow you to create or use UDFs. However, you can use the built-in functions of PostgreSQL.

Limits on data types

The data types of Hologres and PostgreSQL are compatible. However, the data types of Hologres are a subset of the data types of PostgreSQL. For more information, see Data types.

Limits on HoloStudio

Note

HoloStudio is gradually updated to DataStudio. We recommend that you use DataStudio or HoloWeb for data development. This provides more features and simplifies operations. For more information, see Notice on the discontinuation of DataWorks HoloStudio.

  • You can create multiple databases for a Hologres instance. You can also associate a Hologres database with multiple workspaces in the same region.

  • In HoloStudio, you can click Go to DataStudio for Scheduling to go to the DataStudio page for data development. By default, shared resource groups are used. If you want to use exclusive resource groups, contact technical support or join the Hologres DingTalk group. For more information, see Obtain online support for Hologres.

Limits on the purchase of Hologres instances

  • You can buy up to three instances per day within an Alibaba Cloud account.

  • Hologres supports the subscription and pay-as-you-go billing methods. You can change the billing method only from pay-as-you-go to subscription. You cannot change the billing method from subscription to pay-as-you-go.

  • If you stop a pay-as-you-go instance in the Hologres console, you are not charged for computing resources but you are charged for the storage resources of the instance. If you delete the instance, you are no longer charged by Hologres.

  • If your Hologres instance is purchased by using the subscription billing method and the quota of storage resources is exceeded, the billing method is changed to pay-as-you-go for the extra storage resources that you use.