SELECT * FROM DistnmatchReduce ( ON DistnmatchMultipleInput ( ON (SELECT COUNT(1) AS counts, SUM(COUNT(1)) OVER (PARTITION BY column [,...] ORDER BY column) AS rank, column [,...] FROM input_table WHERE column IS NOT NULL GROUP BY column [,...] ) AS input PARTITION BY ANY ON (SELECT column [,...], COUNT(*) AS group_size FROM input_table WHERE column IS NOT NULL GROUP BY column [,...] ) AS groupstats DIMENSION ValueColumn (value_column) [ Tests ('test' [,...]) ] Distributions ('distribution:parameters' [,...]) [ GroupByColumns ({ 'group_by_column' | 'group_by_column_range' }[,...]) ] [ MinGroupSize (min_group_size) ] [ NumCell (cell_size) ] ) PARTITION BY column [,...] );