Resultado de búsqueda
Hace 4 días · In the Create Node dialog box, configure the Name and Path parameters. Note The node name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.). Click Confirm. On the configuration tab of the ODPS SQL node, write and run code in the code editor.
Hace 5 días · Overview. MaxCompute supports the following types of JOINoperations: LEFT OUTER JOIN. It is also called LEFT JOIN. LEFT OUTER JOIN returns all rows in the left table, including the rows that do not match any rows in the right table. Note. In a JOINoperation, the left table is a large table, and the right table is a small table in most cases.
Hace 5 días · odps.sql.mapjoin.memory.max. The size of small tables that are read to the memory when the MAPJOIN statement is executed. Unit: MB. Valid values: 0 to 8192. odps.sql.metering.value.max. The upper limit on resources consumed by an SQL statement. For more information, see Consumption control. -odps.sql.python.version
Hace 2 días · Max Resources Consumed by An SQL Statement. The upper limit for the resources that can be consumed by an SQL job. Formula: Amount of scanned data (GB) × Complexity. This parameter is optional. If you select Pay-as-you-go for Billing Method, we recommend that you configure this parameter to prevent a single SQL job from consuming excessive ...
Hace 1 día · Last Updated:Feb 19, 2024. A task is the basic computing unit of MaxCompute. You can write SQL or MapReduce programs to express the data processing logic, and then submit the programs to MaxCompute for execution. MaxCompute converts the programs into one or more tasks and executes the tasks in parallel in a distributed environment.
Hace 2 días · In the left-side navigation pane of the MaxCompute console, choose Tenants> Users. On the Users page, find the RAM user to which you want to grant permissions, and click Modify Rolein the Actions column. In the Edit Role dialog box, select the role that you created and click OK to complete the authorization operation.
Hace 3 días · Description. GROUPING SETSis an extension of a GROUP BYclause in a SELECTstatement. The GROUPING SETS clause allows you to group your results in multiple ways, without the need to execute multiple SELECTstatements and UNION ALLin sequence. This allows MaxCompute to generate more efficient execution plans with higher performance.
