This topic describes other common statements that are used when you use MaxCompute SQL for your business development.
Cost estimation
Estimates the cost of executing an SQL job based on the amount of input data, number of user-defined functions (UDFs), and complexity of the job. If partition pruning is enabled for the UDFs, you cannot estimate the expense in this case because you cannot determine the number of partitions that are scanned.
Note The result is for reference only. You can view your bill for the actual costs.
- Syntax
cost sql <sql_sentence>;
- Parameter
sql_sentence: the SQL statement for which you want to estimate the execution cost.
- Example
Returned results:cost sql select * from sale_detail;
ID = 20150715113033121xxxxxxx UDF:0 Complexity:1.0 Input:0 Bytes