Version 1.6
This function requires "@coprocessor".
SELECT * FROM NTree@coprocessor ( ON { table | view | (query) } PARTITION BY { 1 | partition_column [,...] } [ ORDER BY ordering_column [,...] ] USING RootNode (root_node_expression) NodeID (node_id_expression) ParentID (parent_id_expression) [ AllowCycles ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] StartsWith ({ 'root' | 'leaf' | starting_node_id_expression }) Direction ({ 'up' | 'down' }) OutputType ({ 'end' | 'all' }) [ MaxDistance (max_distance) ] [ OutputLogMessages ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})] Results (aggregate [,...]) ) AS alias;