ApproxCardinalityReduce version 1.3, ApproxCardinalityMap version 1.2
SELECT * FROM ApproxCardinalityReduce ( ON ( [ SELECT * FROM ] ApproxCardinalityMap ( ON { table | view | (query) } USING InputColumns ({ 'input_column' | input_column_range [,...]) [ ErrorRate (error_tolerance) ] ) AS alias_1 ) PARTITION BY column_name ) AS alias_2;