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') ) ORDER BY node;