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.