ApproxPercentileReduce version 1.6, ApproxPercentileMap version 1.4
SELECT * FROM ApproxPercentileReduce ( ON ([ SELECT * FROM ] ApproxPercentileMap ( ON { table | view | (query) } USING TargetColumns ('target_column' [,...]) [ ErrorRate (error) ] [ GroupColumns ('group_column' [,...]) ] ) AS alias_1 ) PARTITION BY [ 1 | group_column [,...]] USING [ Percentile (percentile [,...]) ] [ TargetColumns ('target_column' [,...]) ] [ GroupColumns ('group_column' [,...]) ] ) AS alias_2;