gTree (version 1.0) - Aster Analytics

SELECT * FROM gTree (
  ON {  table  |  view  | (query) } AS vertices PARTITION BY  key 
  ON {  table  |  view  | (query) } AS edges PARTITION BY  key 
  ON {  table  |  view  | (query) } AS root PARTITION BY  key 
  TargetKey ({ 'edges_column' | 'edges_column_range' }[,...])
  [ AllowCycles ({'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'}) ]
  [ MaxIterNum ('max_depth') ]
  [ Output ({ 'all' | 'end' }) ]
  [ Results ('func(expr) [ AS  alias  ]' [,...]) ]
  [ EdgeResults ('func(expr) [ AS  alias  ]' [,...])) ]
  [ FinalEdgeFlag ({'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'})]
);