GSQL grammar problem

likais · November 25, 2023, 2:48am

How to deal with the edge with the smallest weight that can be filtered from the accumulator of a storage edge?
How to call another query repeatedly in one query?

likais · November 25, 2023, 2:56am

The algorithm of all_pairs shortest path is used, but only one starting node can be input at runtime. How to input multiple starting nodes to reflect its multi-source characteristics?

Victor_Lee · November 27, 2023, 2:58pm

I don’t quite understand what you are asking.
“deal with”: Do you want to find the edge with lowest weight, from some collection of edges? How is this collection of edges defined?
“accumulator of a storage edge”: I don’t follow.
You can put the call inside a loop (WHILE or FOREACH). I believe you can also have it in the ACCUM clause of SELECT statement.

The k_means algorithm in the Graph Data Science Library has an example with a FOREACH loop:

github.com

tigergraph/gsql-graph-algorithms/blob/master/algorithms/Community/k_means/tg_kmeans.gsql

CREATE QUERY tg_kmeans(int k = 2, int max_k = 5, float max_change = 1.0, string v_type, string e_type, bool random = FALSE, BOOL print_results = TRUE, STRING file_path="")  SYNTAX V1 {

    /*
    First Author: <First Author Name>
    First Commit Date:  <First Commit Date>

    Recent Author: <Recent Commit Author Name>
    Recent Commit Date: <Recent Commit Date>


    Repository:
        https://github.com/tigergraph/gsql-graph-algorithms/tree/master/algorithms/Community

    Maturity:
        Production

    Description: 
        Runs k-means clustering algorithm for a range of K values

    Publications:

This file has been truncated. show original

Victor_Lee · November 27, 2023, 3:04pm

Note that the All-Pairs Shortest Path GSQL code at All-Pairs Shortest Path :: TigerGraph Graph Data Science Library is an example, rather than an official part of the Graph Data Science Library.

This query’s input parameters do not include any individual vertices, only the vertex types.

CREATE QUERY tg_all_pairs_shortest( SET v_type_set, SET e_type_set,
STRING wt_attr, STRING wt_type, STRING result_attribute = “”, STRING file_path = “”)