Create a Doris SQL task

Procedure

1. In the top navigation bar of the Dataphin homepage, choose Developer > Data Development.

2. On the Development page, select a Project from the top navigation bar. In Dev-Prod mode, also select an environment.

3. In the navigation pane on the left, select Data Processing > Compute Task. On the Compute Task page, click the icon and select Doris SQL.

4. In the Create Doris SQL Node dialog box, configure the following parameters.

   Parameter	Description
   Task Name	Enter a task name. Maximum 256 characters. Cannot contain: | / \ : ? <> * ".
   Schedule Type	Select a Schedule Type: Recurring Task Node: The system schedules the node to run periodically. Manual Node: The task requires a manual trigger to run.
   Select Directory	Select the directory to store the task. If no directory exists, create a folder: Click the icon above the task list to open the Create Folder dialog box. In the Create Folder dialog box, enter a folder Name and Select A Directory. Click OK.
   Use Template	Turn on or off Use Template to apply a code template. If enabled, also specify Select A Template and Template Version. Template code is read-only. Configure template parameters to complete development. Create an offline computing template.
   Description	Enter a task description. Maximum 1,000 characters.

5. Click OK.

6. On the Doris SQL node tab, write your SQL code in the editor, then click Run.

7. Click Property in the right sidebar. In the Property panel, configure the task's Basic Information, Runtime Parameter, Scheduling Properties (recurring task), Schedule Dependency (recurring task), Runtime Configuration, and Resource Configuration.

   • Basic Information

     Define the task name, responsible person, and description. Configure basic task information.

   • Runtime Parameter

     Assign values to parameter variables used in the task. During scheduling, variables are replaced with the assigned values. Configure runtime parameters for an offline task.

   • Scheduling Properties (recurring task)

     For Recurring Task nodes. Configure alongside Basic Information. Configure scheduling properties.

   • Schedule Dependency (recurring task)

     For Recurring Task nodes. Configure alongside Basic Information. Configure scheduling dependencies.

   • Runtime Configuration

     Set task-level timeout and retry policies. Unconfigured values inherit tenant-level defaults. Configure computing task runtime.

   • Resource Configuration

     Assign a scheduling resource group. The node uses this group's resource quota during scheduling. Configure resources for computing nodes.

8. On the Doris SQL task tab, save and submit the task.

   1. Click the icon above the code editor to save.

   2. Click the icon above the code editor to submit.

9. On the Submitting Log page, confirm the Submission Content and Pre-check results, and enter remarks. For more information, see Guidelines for submitting offline computing nodes.

10. Click OK And Submit.