Hologres can scan a maximum of 50 partitions from a MaxCompute partitioned table during a single query.

If a MaxCompute partitioned table contains more than 50 partitions, we recommend that you:
  1. Specify filter conditions to filter out unnecessary partitions before the query.
  2. Import the table data to Hologres and then query the imported data in Hologres. For more information, see Use SQL statements to import MaxCompute to Hologres.