The ODPS SQL adopts a syntax similar to that of SQL, and is applicable to a distributed scenario, where the amount of data is massive (TB-level) with low real-time requirement. It is an OLAP application oriented to throughput. ODPS SQL is recommended if a business needs to handle thousands or tens of thousands of transactions because it takes a long time to complete the process from preparation to submission of a job.
- Create a business flow.
Click Manual Business Flow in the left-side navigation pane, and select Create Business Flow.
- Create ODPS SQL node.
Right-click Data Development, and select .
- Edit the node code.
For more information about the syntax of the SQL statements, see MaxCompute SQL statements.
- Node scheduling configuration.
Click the Schedule on the right of the node task editing area to go to the Node Scheduling Configuration page. For more information, see Scheduling configuration.
- Submit the node.
After the configuration is completed, click Save in the upper-left corner of the page or press Ctrl+S to submit (and unlock) the node to the development environment.
- Publish a node task.
For more information about the operation, see Release management.
- Test in the production environment.
For more information about the operation, see Manual task.