Prefix

Overview

UQL support the following prefix keywords for a clause or the entire UQL statement:

Prefix Keyword	Description	Scope
`TRY`	Used to create new graphsets, schemas and properties without returning an error message in case of failure. Successful creations are unaffected. If not using `TRY`, creation failure will return an error message, such as duplicated names.	Current `create()` clause
`OPTIONAL`	Used to verify if each subquery within a query has returns. If a subquery finds no results, null values are returned in place of nodes and/or edges. If not using `OPTIONAL`, subquery with no results will have no return.	Current query clause
`EXPLAIN`	Return the operation plan of the entire UQL statement without executing it.	Entire UQL statement
`PROFILE`	Return the operation plan of the entire UQL statement and the time cost for each step during its execution.	Entire UQL statement
`DEBUG`	Return the number of calls and time cost for each step in the operation plan of the entire UQL statement during its execution.	Entire UQL statement
`EXEC TASK`	Send the entire UQL statement to the analytics node (algo node) of the cluster for execution	Entire UQL statement

NOTE

Prefix keywords are all case insensitive.

UQL
explain n({@movie} as movies).e({@filmedIn}).n({@country.name == "US"}) as paths  
group by  movies.genre 
return movies.genre, count(movies)

UQL
profile n({@movie} as movies).e({@filmedIn}).n({@country.name == "US"}) as paths  
group by  movies.genre 
return movies.genre, count(movies)

UQL
debug n({@movie} as movies).e({@filmedIn}).n({@country.name == "US"}) as paths  
group by  movies.genre 
return movies.genre, count(movies)