Debug a job

Background information

When you use the SQL preview feature, you can use online data or specify debugging data. You can debug complex jobs that include multiple SELECT or INSERT statements. SQL query statements allow you to use UPSERT statements that contain update operations, such as count(*).

Prerequisites

A session cluster for SQL preview is created. Before you debug a job, the system checks whether a session cluster that allows SQL preview is created. If such a session cluster is not created, the system prompts you to create a session cluster and guides you through the cluster configuration. For more information about how to configure a session cluster, see Configure a session cluster.

Limits

• You can debug only SQL jobs by clicking Execute in the console of fully managed Flink. You cannot click Execute to debug Python jobs or DataStream jobs.
• MySQL CDC source tables are not written in append-only mode. Therefore, you cannot debug data of MySQL CDC source tables for session clusters of VVR 4.0.8 or an earlier version.

Procedure

1. Go to the Draft Editor page and create an SQL job.
   1. Log on to the Realtime Compute for Apache Flink console.
   2. On the Fully Managed Flink tab, find the workspace that you want to manage and click Console in the Actions column.
   3. In the left-side navigation pane, click Draft Editor.
   4. Click New.
   5. In the dialog box that appears, enter the job configuration information and click OK.
      You must select STREAM / SQL for Type.
2. Create a source table and a result table separately.
   Write SQL statements for the source table and the result table and click Execute. The created tables appear in the Tables list of the Schemas tab. You can click the name of a specific table to view the table fields and data types. For example, you can execute the following statements to create a source table named datagen, a result table named blackhole, and a result table named blackhole_cnt.

   • Statement for creating a source table named datagen

     CREATE TABLE `vvp`.`default`.`datagen` (
       `id`   VARCHAR(2147483647),
       `name` VARCHAR(2147483647)
     ) WITH (
       'connector' = 'datagen',
       'rows-per-second' = '5'
     );                        

   • Statement for creating a result table named blackhole

     CREATE TABLE `vvp`.`default`.`blackhole` (
       `id` VARCHAR(2147483647),
       `name` VARCHAR(2147483647)
     ) WITH (
       'connector' = 'blackhole'
     );                        

   • Statement for creating a result table named blackhole_cnt

     CREATE TABLE `vvp`.`default`.`blackhole_cnt` (
       `cnt` BIGINT
     ) WITH (
       'connector' = 'blackhole'
     );                    

3. Write DML statements that are used to debug the job.
   You can execute the following statements to write the data that is read from the source table datagen directly to the result table blackhole, and write the total number of data records in the data to the result table blackhole_cnt:

   BEGIN STATEMENT SET;
   
   insert into blackhole
     select *
       from datagen;
   
   insert into `blackhole_cnt`
     select count(*)
       from `datagen`;
   
   END;

4. Click Validate.
   In the lower part of the SQL script editor, you can view the verification result of the SQL syntax. Only SQL scripts that pass the verification can be executed.
5. Click Execute.
6. Configure debugging data.
   If you use online data for debugging, click Execute. If you need to use debugging data, you must upload the data first. The following table describes the parameters.

   Parameter	Description
   Download Mock Data Template	You can download the debugging data template to edit data. The template is adapted to the data structure of the source table.
   Upload mock data	If you need to debug a job by using debugging data, you can download the debugging data template, upload the data after you edit it, and then select Use Mock data. Limits on debugging data files: Only a CSV file is supported. A CSV file must contain a table header, such as id (INT). A CSV file can contain a maximum of 1,000 data records but cannot be greater than 1 MB.
   Preview data	After you upload the debugging data, click the icon on the left side of the source table name to preview the data and download the debugging data.
   Execution Code Preview	The job debugging feature automatically modifies the DDL statements in source tables and result tables. However, this feature does not change the code in jobs. You can preview code details in the lower part of Execution Code Preview.

7. Click Execute.
   After you click Execute, the debugging result appears in the lower part of the SQL script editor.

   

   Note By default, fully managed Flink reads a maximum of 1,000 data records. If the maximum value is reached, fully managed Flink stops reading data.