Skip to main content

SingleStoreDB v7.3

PROFILE PIPELINE JSON

The PROFILE PIPELINE JSON command is used to estimate the resources needed for a pipeline with JSON data.

Syntax

PROFILE PIPELINE <pipeline_name> JSON

Remarks

  • Command can only run on a stopped pipeline.

  • Command output is in JSON format.

  • See the Permissions Matrix for the required permission.

Output

Pipeline details in a JSON format.

Examples

CREATE TABLE emps(emp_id INT, DATA JSON);
CREATE PIPELINE <pipeline_name> AS LOAD DATA fs '/<file_name.csv>' 
  INTO TABLE emps
  FIELDS TERMINATED BY ','    
  ENCLOSED BY '"'
  IGNORE 1 LINES;
PROFILE PIPELINE <pipeline_name> JSON;

****
{
    "plan_warnings": {
},
    "execution_warnings": {
},
    "mpl_path":"\/var\/lib\/memsql\/73fbb32c-79b7-4b28-bc6e-49142e28a6c5\/plancache\/c1d\/RunPipeline_jtest2_profile_emps__et_al_c1d74837c7e4f23c519ff45b74423fe1ea676d2c15afba6f46602effe1496c89_5e56f6d99b9e220c",
    "profile":[
        {
            "executor":"Gather",
            "keyId":4295163904,
            "partitions":"all",
            "est_rows":"1",
            "est_rows_source":"JOIN",

Note

The example above only shows a portion of the output.

In this section: