Online debugging

Procedure

1. Develop a job. For more information, see Develop a job.
2. Modify the type parameter in the data definition language (DDL) statements of data storage resources.
   • Source table: type = 'random'
   • Result table: type = 'print'
3. Publish the job. For more information, see Publish a job.
4. Start the job. For more information, see Start a job.

Connectors

Parameters in a connector table

• random table

  Parameter	Description
  type	Required. The type of the connector. The value can only be random.
  interval	Optional. The time interval at which data is generated. Unit: milliseconds. Default value: 500.

• print table

  Parameter	Description
  type	Required. The type of the connector. The value can only be print.
  ignoreWrite	Optional. Specifies whether to ignore write operations. Default value: false. Valid values: false: Data is written to the result table, and logs are generated. true: Data is not written to the result table. The result table is empty, and no logs are generated.

Examples

• Test code

  CREATE TABLE random_source (
    instr               VARCHAR
  ) WITH (
    type = 'random'
  );
  
  CREATE TABLE print_sink(
    instr VARCHAR,
    substr VARCHAR,
    num INT
  )with(
    type = 'print'
  );
  
  INSERT INTO print_sink
  SELECT
    instr,
    SUBSTRING(instr,0,5) AS substr,
    CHAR_LENGTH(instr) AS num
  FROM random_source

• Test results

Query online debugging results