PROFILE PIPELINE JSON
On this page
The PROFILE PIPELINE JSON command is used to estimate the resources needed for a pipeline and outputs the result in JSON format.
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 empsFIELDS 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.
Last modified: June 17, 2024