SELECT * FROM Path_Start ( ON (SELECT * FROM Path_Summarizer ( ON (SELECT * FROM Path_Generator ( ON clickstream1 SeqColumn ('path') Delimiter (',') ) ) PARTITION BY prefix SeqColumn ('sequence') PrefixColumn ('prefix') PartitionNames ('prefix') Delimiter (',') CountColumn ('cnt') Hash ('false') ) ) PARTITION BY (parent) CountColumn ('cnt') Delimiter (',') ParentColumn ('parent') PartitionNames ('partitioned') NodeColumn ('node') ) ORDER BY node;