Louvain Query showing syntax error

Phan · March 22, 2022, 3:26pm

Hi,

im trying to get familar with graph algorithms and wanted to try out the Louvain algorithm.

I copied and pasted the query from here:

tigergraph/gsql-graph-algorithms/blob/master/algorithms/Community/louvain/tg_louvain.gsql

CREATE QUERY tg_louvain(SET<STRING> v_type, SET<STRING> e_type, STRING wt_attr = "weight", INT max_iter = 10, 
  STRING result_attr = "cid", STRING file_path = "", BOOL print_info = FALSE)  SYNTAX V1 {

  /*
  louvain community detection algorithm
  add keyword DISTRIBUTED for cluster environment

  Parameters:
  v_type: vertex types to traverse
  e_type: edge types to traverse
  wt_attr: attribute name for edge weights use empty string is graph is unweighted
  wt_attr type is hardcoded to FLOAT INT or DOUBLE can be supported by changing all `e.getAttr(wt_attr, "FLOAT")`
  to `e.getAttr(wt_attr, "INT")` or `e.getAttr(wt_attr, "DOUBLE")`
  * note: when there is a weight attribute missmatch, there may not be an explicit error message
  all print results showing 0 data are present is an indication that there might be a weight attribute missmatch
  
  max_iter: maximum iteration of louvain optimization
  result_attr: attribute name to assign community id results to; use empty string to skip
  file_path: file path to write CSV output to; use empty string to skip
  print_info: print louvain execution info

This file has been truncated. show original

into graph studio but i get an error saying:
(66, 17) Error: The alias t.@max_best_move cannot be determined.

Im using a local docker setup with the latest tigergraph image which has the GSQL version: 3.1.

Am i missing a step or something? Any help would be appreciated.

Screenshot of the error:

Best
Phan

Phan · March 29, 2022, 7:55am

Upgraded to GSQL version 3.5 and the error is gone now

Liz_Anaya · March 29, 2022, 4:59pm

Awesome! Thanks for sharing the solution, @Phan!