nested queries - Does Vertica DB does support pipelining requests in one connection? -

I want to know whether Vertica supports DB piping requests To be more clear, if we have multiple Can request.

Pipelinated requests are possible in Vertica, as long as you have the launch that is already on your column If the sort is done, the adapter will use the fast groupbipi pipeline operation. This shows your entire plan as GroupBiPipeline , see examples here:

  = & gt; Explain the number selected from the WHEER customer_gend = 'Woman' from customer_decorations; Access path: + -Until misuse [cost: 161, lines: 1] (Pat ID: 1). Set: Counting (different customer.app.nnl_incom). + --- & gt; Groupbie pipeline [cost: 158, lines: 10k] (Pat ID: 2). | By Group: customer_dimension.annual_income | | + --- & gt; Storage access to customer-dimension [cost: 144, lines: 47K] (Pat ID: 3). | | Projection: public.customer_dimension_DBD_1_rep_vmartdb_design_vmartdb_design_node0001 | | | Making physical: customer_development | | Filter: (customer_dimension.customer_gender = 'female')