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