MaxCompute:Computing pricing (pay-as-you-go)

Subscription

After you purchase subscription computing resources, you can monitor and manage the resources using resource observation. For more information, see Resource Monitoring.

We recommend that you select the pay-as-you-go billing method the first time you use MaxCompute. If you select the subscription billing method, you purchase a specific amount of computing resources. If you are a new user, you may consume fewer resources than the purchased resources. Some resources may remain idle. In this case, we recommend that you use the pay-as-you-go billing method. The pay-as-you-go billing method is more cost-effective because you are charged based on the amount of resources that you consume.

Billing for standard SQL jobs

Each time you run an SQL job, MaxCompute calculates the fee based on the Amount Of Input Data In Computing and SQL Complexity. On the following day, MaxCompute aggregates the fees for all executed SQL jobs into one bill within your Alibaba Cloud account. Then, MaxCompute deducts the fees from the balance of your Alibaba Cloud account.

Fee for a standard SQL job = Amount of input data in computing × SQL complexity × Unit price of a standard SQL job

• Amount Of Input Data In Computing: the amount of data scanned by an SQL job. Most SQL jobs support partition filtering and column pruning. Therefore, in most cases, this value is less than the amount of data in the source table.

  • Partition filtering: If you submit an SQL statement that contains the WHERE ds > 20130101 clause. ds in the clause is the partition key column. You are charged only for the data in the partitions that are read.

  • Column pruning: If you submit the SQL statement SELECT f1,f2,f3 FROM t1;, you are charged only for the data in columns f1, f2, and f3 of table t1. You are not charged for the data in the other columns.

• SQL Complexity: The complexity of an SQL job is calculated based on the number of keywords in the SQL statements of the SQL job.

  • Number of SQL keywords = Number of JOIN clauses + Number of GROUP BY clauses + Number of ORDER BY clauses + Number of DISTINCT clauses + Number of window functions + MAX(Number of INSERT statements|Number of UPDATE statements|Number of DELETE statements - 1, 1).

  • Calculation of SQL complexity:

    • If the number of SQL keywords is less than or equal to 3, the complexity of an SQL job is 1.

    • If the number of SQL keywords is less than or equal to 6 but greater than or equal to 4, the complexity of an SQL job is 1.5.

    • If the number of SQL keywords is less than or equal to 19 but greater than or equal to 7, the complexity of an SQL job is 2.

    • If the number of SQL keywords is greater than or equal to 20, the complexity of an SQL job is 4.

  For more information about SQL keywords, see JOIN, GROUP BY, ORDER BY, Window functions, INSERT, UPDATE|DELETE.

COST SQL <SQL Sentence>;

odps@ $odps_project >COST SQL SELECT DISTINCT total1 FROM
(SELECT id1, COUNT(f1) AS total1 FROM in1 GROUP BY id1) tmp1
ORDER BY total1 DESC LIMIT 100;
Intput:1825361100.8 Bytes
Complexity:1.5

1.7 × 1.5 × 0.0438 = 0.11 USD

Billing for SQL jobs that reference external tables

Since March 2019, you are charged for MaxCompute SQL jobs that reference external tables based on the pay-as-you-go billing method.

Fee for an SQL job = Amount of input data in computing × Unit price of SQL jobs that reference external tables

Pay-as-you-go billing for MapReduce jobs

Since December 19, 2017, you are charged for MaxCompute MapReduce jobs based on the pay-as-you-go billing method.

Fee for MapReduce jobs of the day = Number of billable hours × Unit price (USD per hour)

Number of billable hours of a MapReduce job = Number of hours for which a job runs × Number of CPU cores consumed by the job

For example, if a MapReduce job that runs for 0.5 hours consumes 100 CPU cores, the number of billable hours is 50 based on the following formula: 100 cores × 0.5 hours = 50.

Pay-as-you-go billing for Spark jobs

Fee for Spark jobs of the day = Number of billable hours × Unit price (USD 0.1041 per hour)

The number of billable hours of a Spark job is calculated based on the following formula:

Number of billable hours of a Spark job = MAX[Number of CPU cores × Number of hours for which a job runs, ROUND UP(Memory size × Number of hours for which a job runs/4)]

For example, if a Spark job that runs for 1 hour consumes 2 CPU cores and 5 GB of memory, the number of billable hours is 2 based on the following formula: MAX[2 × 1, ROUND UP(5 × 1/4)] = 2. If a Spark job that runs for 1 hour consumes 2 CPU cores and 10 GB of memory, the number of billable hours is 3 based on the following formula: MAX[2 × 1, ROUND UP(10 × 1/4)] = 3.

Pay-as-you-go billing for Mars jobs

Fee for Mars jobs of the day = Number of billable hours × Unit price (USD 0.1041 per hour)

After a Mars job is run, MaxCompute calculates the billable hours of the job. On the following day, MaxCompute aggregates the fees for all executed Mars jobs into one bill within your Alibaba Cloud account. Then, MaxCompute deducts the fees from the balance of your Alibaba Cloud account.

Pay-as-you-go billing for MCQA jobs

Since October 1, 2020, you are charged for MCQA jobs based on the pay-as-you-go billing method. For more information, see Query acceleration (MCQA).

Each time you run an MCQA job, MaxCompute calculates the fee based on the amount of input data of the job. On the following day, MaxCompute aggregates the fees for all executed MCQA jobs.

Fee for an MCQA job = Amount of input data for the MCQA job × Unit price (USD 0.0438 per GB)

Pay-as-you-go billing for MaxFrame jobs

After a MaxFrame job is run, MaxCompute calculates the CU-hours (billable hours) consumed by the job. On the following day, MaxCompute aggregates the fees for all MaxFrame jobs into one bill within your Alibaba Cloud account before 06:00. Then, MaxCompute deducts the fees from the balance of your Alibaba Cloud account.

Fee for MaxFrame jobs of the day = Number of billable hours × Unit price

The following table describes the billing rules for MaxFrame jobs.

References

• If you want to know the distribution of your MaxCompute fees and prevent the fees from exceeding your expectations when you use MaxCompute, you can obtain and analyze your MaxCompute bills to maximize resource utilization and reduce costs. For more information, see Analyze the usage records of MaxCompute bills.

• Fees are incurred when you use MaxCompute for development. If daily consumption is stable most of the time but the fees surge in a specific period, you can perform a cost analysis to identify the projects and jobs that cause the surges, except for surges due to business growth. Then, you can optimize and adjust the jobs as soon as possible to optimize costs. For more information, see Troubleshoot an unexpected surge in the postpaid fees of MaxCompute.