| set search_path to "$user",public,madlib; |
| -- Basic methods |
| select cmsketch_count(i,5) from generate_series(1,10000) as T(i); |
| cmsketch_count |
| ---------------- |
| 10 |
| (1 row) |
| |
| select cmsketch_rangecount(i,1,1025) from generate_series(1,10000) as T(i); |
| cmsketch_rangecount |
| --------------------- |
| 1033 |
| (1 row) |
| |
| select cmsketch_rangecount(i,1,200) from generate_series(1,10000) as R(i); |
| cmsketch_rangecount |
| --------------------- |
| 213 |
| (1 row) |
| |
| select cmsketch_width_histogram(cmsketch(i), min(i), max(i), 4) from generate_series(1,10000) as R(i); |
| cmsketch_width_histogram |
| -------------------------------------------------------------------------------- |
| [0:3][0:2]={{1,2500,2511},{2501,5000,2515},{5001,7500,2516},{7501,10000,2516}} |
| (1 row) |
| |
| select min(i), |
| cmsketch_centile(i, 25) AS quartile1, |
| cmsketch_centile(i, 50) AS quartile2, |
| cmsketch_median(i) AS median, |
| cmsketch_centile(i, 75) AS quartile3, |
| max(i) |
| from generate_series(1,10000) as R(i); |
| min | quartile1 | quartile2 | median | quartile3 | max |
| -----+-----------+-----------+--------+-----------+------- |
| 1 | 2500 | 5000 | 5000 | 7500 | 10000 |
| (1 row) |
| |
| select cmsketch_depth_histogram(i, 4) from generate_series(1,10000) as R(i); |
| cmsketch_depth_histogram |
| ----------------------------------------------------------------------------------------------------------------- |
| [0:3][0:2]={{-9223372036854775807,2500,2505},{2501,5000,2515},{5001,7500,2516},{7501,9223372036854775806,2510}} |
| (1 row) |
| |
| -- tests for all-NULL column |
| select cmsketch(NULL) from generate_series(1,10000) as R(i) where i < 0; |
| cmsketch |
| ---------- |
| |
| (1 row) |
| |
| select cmsketch_centile(NULL, 2) from generate_series(1,10000) as R(i) where i < 0; |
| cmsketch_centile |
| ------------------ |
| |
| (1 row) |
| |