Version 1.2
This function requires "@coprocessor".
SELECT * FROM NTree@coprocessor ( ON { table | view | (query) } PARTITION BY partition_column [,...] [ ORDER BY ordering_column [,...] ] USING Root_Node (root_node_expression) Node_ID (node_id_expression) Parent_ID (parent_id_expression) AllowCycles ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) Starts_With ({ 'root' | 'leaf' | starting_node_id_expression }) Mode ({ 'up' | 'down' }) Output ({ 'end' | 'all' }) [ MaxDistance (max_distance) ] [ Logging ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})] Result (aggregate [,...]) ) AS alias;