ApproximatePercentile.sql

--Syntax (ApproxPercentileMap version 1.1; 
--ApproxPercentileReduce version 1.0)

--The synopsis below shows the syntax for invoking the approximate percentile function for 
--a column of data, grouping the data by a different set of columns:

SELECT * FROM ApproxPercentileReduce(
  ON(
    SELECT * FROM ApproxPercentileMap(
      ON {table_name | view_name | (query)}
      TARGET_COLUMN('column_name')
      ERROR(tolerance_value)
      [GROUP_COLUMNS('column_name' [, ...])]
    )
  )
  PARTITION BY expression [, ...]
  PERCENTILE(percentile [, ...])
  [GROUP_COLUMNS('column_name' [, ...])]
);