Overview

The CALL statement can invoke a system-defined procedure. Ultipa provides a range of built-in procedures for tasks such as managing graph projections, running algorithms, and more.

<call procedure statement> ::=
  "CALL" <procedure reference> [ <yield clause> ]

Details

• The YIELD clause can be used to select and rename columns from the binding table produced by the procedure (if applicable), making them available for use and reference in subsequent parts of the query.

HDC Graph Procedures

An HDC graph resides in the memory of a HDC (High-Density Computing) server, containing either full or partial data from a graphset loaded from the physical storage of shard servers. For more details, refer to HDC Graphs.

Job Procedures

Certain GQL queries, such as projection creation and algorithm writeback, are designed to run as back-end jobs. The results of some jobs, such as files generated by algorithms, are stored in the graphsets on which they are executed and can be retrieved later, unless cleared.

Showing Jobs

The procedure job.show() retrieves information about jobs in the current graphset.

To retrieve all jobs:

CALL job.show()

To retrieve the job with id 83:

CALL job.show(83)