[datasketches-postgresql] branch master updated: some tests for req sketch

[al...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

alsay pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/datasketches-postgresql.git


The following commit(s) were added to refs/heads/master by this push:
     new 004c2bd  some tests for req sketch
004c2bd is described below

commit 004c2bd84c83723aba2f6fd5a77744f1918e09a6
Author: AlexanderSaydakov <Al...@users.noreply.github.com>
AuthorDate: Thu Mar 4 17:33:45 2021 -0800

    some tests for req sketch
---
 test/req_sketch_test.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)

diff --git a/test/req_sketch_test.sql b/test/req_sketch_test.sql
new file mode 100644
index 0000000..b2dcbec
--- /dev/null
+++ b/test/req_sketch_test.sql
@@ -0,0 +1,29 @@
+drop extension if exists datasketches cascade;
+create extension datasketches;
+
+drop table if exists req_sketch_test;
+create table req_sketch_test(sketch req_float_sketch);
+
+-- default k
+insert into req_sketch_test
+  select req_float_sketch_build(value)
+  from (values (1), (2), (3), (4), (5)) as t(value)
+;
+
+-- k = 20
+insert into req_sketch_test
+  select req_float_sketch_build(value, 20)
+  from (values (6), (7), (8), (9), (10)) as t(value)
+;
+
+-- get min and max values
+select req_float_sketch_get_quantiles(sketch, array[0, 1]) as min_max from req_sketch_test;
+select req_float_sketch_to_string(sketch) from req_sketch_test;
+
+-- default k, median
+select req_float_sketch_get_quantile(req_float_sketch_merge(sketch), 0.5) as median from req_sketch_test;
+-- k = 20, rank of value 6
+select req_float_sketch_get_rank(req_float_sketch_merge(sketch, 20), 6) as rank from req_sketch_test;
+
+drop table req_sketch_test;
+drop extension datasketches;


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org