Option 1: For Multiple-Node Data Sets - Aster Analytics

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 [,...] 
);