Managing Flink Templates

Flink SQL Sample Template

The template list displays existing sample templates for Flink SQL jobs. Table 1 describes the parameters in the template list.

The scenarios of sample templates can be different, which are subject to the console.

Flink OpenSource SQL Sample Template

The template list displays existing sample templates for Flink SQL OpenSource jobs. Table 1 describes the parameters in the template list.

The existing sample templates apply to the following scenarios:

• Create a wide table of order information from the dimension table of address information.
• Generate statistics on indicators such as the daily transaction amount, number of orders, and number of paid users in real time.
• Generate statistics on offerings with the highest real-time click-through rate.

Custom Templates

The custom template list displays all Jar job templates. Table 1 describes parameters in the custom template list.

Creating a Template

You can create a template using any of the following methods:

• Creating a template on the Template Management page
  1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates.
  2. Click Create Template in the upper right corner of the page. The Create Template dialog box is displayed.
  3. Specify Name and Description.
     Figure 1 Creating a Flink template
     

     Table 4 Template parameters

     Parameter	Description
     Type	Template type Flink SQL job template Flink OpenSource SQL job template
     Name	Template name. Enter 1 to 64 characters. Only letters, numbers, hyphens (-), and underscores (_) are allowed. NOTE: The template name must be unique.
     Description	Description of a template. It contains 0 to 512 characters.
     Tags	Tags used to identify cloud resources. A tag includes the tag key and tag value. If you want to use the same tag to identify multiple cloud resources, that is, to select the same tag from the drop-down list box for all services, you are advised to create predefined tags on the Tag Management Service (TMS). For details, see Tag Management Service User Guide. NOTE: A maximum of 20 tags can be added. Only one tag value can be added to a tag key. The key name in each resource must be unique. Tag key: Enter a tag key name in the text box. NOTE: A tag key can contain a maximum of 128 characters. Only letters, numbers, spaces, and special characters (_.:=+-@) are allowed, but the value cannot start or end with a space or start with _sys_. Tag value: Enter a tag value in the text box. NOTE: A tag value can contain a maximum of 255 characters. Only letters, numbers, spaces, and special characters (_.:=+-@) are allowed. The value cannot start or end with a space.

  4. Click OK to enter the editing page.
     The Table 5 describes the parameters on the template editing page.

     Table 5 Template parameters

     Parameter	Description
     Name	You can modify the template name.
     Description	You can modify the template description.
     Saving Mode	Save Here: Save the modification to the current template. Save as New: Save the modification as a new template.
     SQL statement editing area	In the area, you can enter detailed SQL statements to implement business logic. For details about how to compile SQL statements, see Data Lake Insight SQL Syntax Reference.
     Save	Save the modifications.
     Create Job	Use the current template to create a job.
     Format	Format SQL statements. After SQL statements are formatted, you need to compile SQL statements again.
     Theme Settings	Change the font size, word wrap, and page style (black or white background).

  5. In the SQL statement editing area, enter SQL statements to implement service logic. For details about how to compile SQL statements, see Data Lake Insight SQL Syntax Reference.
  6. After the SQL statement is edited, click Save in the upper right corner to complete the template creation.
  7. (Optional) If you do not need to modify the template, click Create Job in the upper right corner to create a job based on the current template. For details about how to create a job, see Creating a Flink SQL Job, and Creating a Flink Jar Job.
• Creating a template based on an existing job template
  1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
  2. In the row where the desired template is located in the custom template list, click Edit under Operation to enter the Edit page.
  3. After the modification is complete, set Saving Mode to Save as New.
  4. Click Save in the upper right corner to save the template as a new one.

• Creating a template using a created job
  1. In the left navigation pane of the DLI management console, choose Job Management > Flink Jobs. The Flink Jobs page is displayed.
  2. Click Create Job in the upper right corner. The Create Job page is displayed.
  3. Specify parameters as required.
  4. Click OK to enter the editing page.
  5. After the SQL statement is compiled, click Set as Template.
  6. In the Set as Template dialog box that is displayed, specify Name and Description and click OK.
• Creating a template based on the existing job
  1. In the left navigation pane of the DLI management console, choose Job Management > Flink Jobs. The Flink Jobs page is displayed.
  2. In the job list, locate the row where the job that you want to set as a template resides, and click Edit in the Operation column.
  3. After the SQL statement is compiled, click Set as Template.
  4. In the Set as Template dialog box that is displayed, specify Name and Description and click OK.

Creating a Job Based on a Template

You can create jobs based on sample templates or custom templates.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates.
2. In the sample template list, click Create Job in the Operation column of the target template. For details about how to create a job, see Creating a Flink SQL Job and Creating a Flink Jar Job.

Modifying a Template

After creating a custom template, you can modify it as required. The sample template cannot be modified, but you can view the template details.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
2. In the row where the template you want to modify is located in the custom template list, click Edit in the Operation column to enter the Edit page.
3. In the SQL statement editing area, modify the SQL statements as required.
4. Set Saving Mode to Save Here.
5. Click Save in the upper right corner to save the modification.

Deleting a Template

You can delete a custom template as required. The sample templates cannot be deleted. Deleted templates cannot be restored. Exercise caution when performing this operation.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
2. In the custom template list, select the templates you want to delete and click Delete in the upper left of the custom template list.

   Alternatively, you can delete a template by performing the following operations: In the custom template list, locate the row where the template you want to delete resides, and click More > Delete in the Operation column.

3. In the displayed dialog box, click Yes.