This is an automated email from the ASF dual-hosted git repository.
qiaojialin pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new a2564e0e fix the data of PACF、Percentile、Quantile function (#239)
a2564e0e is described below
commit a2564e0e0e2dfe17eb635a4cac471481ad060ae4
Author: wanghui42 <[email protected]>
AuthorDate: Fri Nov 8 15:57:30 2024 +0800
fix the data of PACF、Percentile、Quantile function (#239)
---
src/UserGuide/Master/Reference/UDF-Libraries.md | 303 +++++++++-----------
src/UserGuide/V1.2.x/Reference/UDF-Libraries.md | 303 +++++++++-----------
src/UserGuide/latest/Reference/UDF-Libraries.md | 303 +++++++++-----------
src/zh/UserGuide/Master/Reference/UDF-Libraries.md | 283 +++++++++----------
src/zh/UserGuide/V1.2.x/Reference/UDF-Libraries.md | 308 +++++++++++++--------
src/zh/UserGuide/latest/Reference/UDF-Libraries.md | 305 +++++++++-----------
6 files changed, 848 insertions(+), 957 deletions(-)
diff --git a/src/UserGuide/Master/Reference/UDF-Libraries.md
b/src/UserGuide/Master/Reference/UDF-Libraries.md
index 0bf5f5f3..a01332f2 100644
--- a/src/UserGuide/Master/Reference/UDF-Libraries.md
+++ b/src/UserGuide/Master/Reference/UDF-Libraries.md
@@ -1001,52 +1001,47 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
............
-Total line number = 10000
+Total line number = 20
```
SQL for query:
```sql
-select mad(s0) from root.test
+select mad(s1) from root.test
```
Output series:
```
-+-----------------------------+------------------+
-| Time| mad(root.test.s0)|
-+-----------------------------+------------------+
-|1970-01-01T08:00:00.000+08:00|0.6806197166442871|
-+-----------------------------+------------------+
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
```
##### Approximate Query
@@ -1056,16 +1051,16 @@ By setting `error` within (0,1), the function queries
the approximate MAD.
SQL for query:
```sql
-select mad(s0, "error"="0.01") from root.test
+select mad(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+---------------------------------+
-| Time|mad(root.test.s0, "error"="0.01")|
+| Time|mad(root.test.s1, "error"="0.01")|
+-----------------------------+---------------------------------+
-|1970-01-01T08:00:00.000+08:00| 0.6806616245859518|
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
+-----------------------------+---------------------------------+
```
@@ -1097,51 +1092,45 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
```
SQL for query:
```sql
-select median(s0, "error"="0.01") from root.test
+select median(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+------------------------------------+
-| Time|median(root.test.s0, "error"="0.01")|
+| Time|median(root.test.s1, "error"="0.01")|
+-----------------------------+------------------------------------+
-|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+|1970-01-01T08:00:00.000+08:00| 0.0|
+-----------------------------+------------------------------------+
```
@@ -1349,52 +1338,35 @@ This function is used to calculate partial
autocorrelation of input series by so
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
SQL for query:
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
Output series:
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
### Percentile
@@ -1427,37 +1399,31 @@ The function is used to compute the exact or
approximate percentile of a numeric
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
+Total line number = 20
```
SQL for query:
@@ -1469,11 +1435,11 @@ select percentile(s0, "rank"="0.2", "error"="0.01")
from root.test
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|percentile(root.test.s0, "rank"="0.2",
"error"="0.01")|
-+-----------------------------+------------------------------------------------------+
-|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
```
### Quantile
@@ -1506,53 +1472,36 @@ The function is used to compute the approximate
quantile of a numeric time serie
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
SQL for query:
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
diff --git a/src/UserGuide/V1.2.x/Reference/UDF-Libraries.md
b/src/UserGuide/V1.2.x/Reference/UDF-Libraries.md
index af4c7a25..eeb068b4 100644
--- a/src/UserGuide/V1.2.x/Reference/UDF-Libraries.md
+++ b/src/UserGuide/V1.2.x/Reference/UDF-Libraries.md
@@ -917,52 +917,47 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
............
-Total line number = 10000
+Total line number = 20
```
SQL for query:
```sql
-select mad(s0) from root.test
+select mad(s1) from root.test
```
Output series:
```
-+-----------------------------+------------------+
-| Time| mad(root.test.s0)|
-+-----------------------------+------------------+
-|1970-01-01T08:00:00.000+08:00|0.6806197166442871|
-+-----------------------------+------------------+
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
```
##### Approximate Query
@@ -972,16 +967,16 @@ By setting `error` within (0,1), the function queries the
approximate MAD.
SQL for query:
```sql
-select mad(s0, "error"="0.01") from root.test
+select mad(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+---------------------------------+
-| Time|mad(root.test.s0, "error"="0.01")|
+| Time|mad(root.test.s1, "error"="0.01")|
+-----------------------------+---------------------------------+
-|1970-01-01T08:00:00.000+08:00| 0.6806616245859518|
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
+-----------------------------+---------------------------------+
```
@@ -1007,51 +1002,45 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
```
SQL for query:
```sql
-select median(s0, "error"="0.01") from root.test
+select median(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+------------------------------------+
-| Time|median(root.test.s0, "error"="0.01")|
+| Time|median(root.test.s1, "error"="0.01")|
+-----------------------------+------------------------------------+
-|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+|1970-01-01T08:00:00.000+08:00| 0.0|
+-----------------------------+------------------------------------+
```
@@ -1295,52 +1284,35 @@ This function is used to calculate partial
autocorrelation of input series by so
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
SQL for query:
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
Output series:
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
### Percentile
@@ -1367,37 +1339,31 @@ The function is used to compute the exact or
approximate percentile of a numeric
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
+Total line number = 20
```
SQL for query:
@@ -1409,11 +1375,11 @@ select percentile(s0, "rank"="0.2", "error"="0.01")
from root.test
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|percentile(root.test.s0, "rank"="0.2",
"error"="0.01")|
-+-----------------------------+------------------------------------------------------+
-|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
```
### Quantile
@@ -1440,53 +1406,36 @@ The function is used to compute the approximate
quantile of a numeric time serie
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
SQL for query:
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
diff --git a/src/UserGuide/latest/Reference/UDF-Libraries.md
b/src/UserGuide/latest/Reference/UDF-Libraries.md
index b7e2d38d..0fedc360 100644
--- a/src/UserGuide/latest/Reference/UDF-Libraries.md
+++ b/src/UserGuide/latest/Reference/UDF-Libraries.md
@@ -1000,52 +1000,47 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
............
-Total line number = 10000
+Total line number = 20
```
SQL for query:
```sql
-select mad(s0) from root.test
+select mad(s1) from root.test
```
Output series:
```
-+-----------------------------+------------------+
-| Time| mad(root.test.s0)|
-+-----------------------------+------------------+
-|1970-01-01T08:00:00.000+08:00|0.6806197166442871|
-+-----------------------------+------------------+
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
```
##### Approximate Query
@@ -1055,16 +1050,16 @@ By setting `error` within (0,1), the function queries
the approximate MAD.
SQL for query:
```sql
-select mad(s0, "error"="0.01") from root.test
+select mad(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+---------------------------------+
-| Time|mad(root.test.s0, "error"="0.01")|
+| Time|mad(root.test.s1, "error"="0.01")|
+-----------------------------+---------------------------------+
-|1970-01-01T08:00:00.000+08:00| 0.6806616245859518|
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
+-----------------------------+---------------------------------+
```
@@ -1096,51 +1091,45 @@ Input series:
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
```
SQL for query:
```sql
-select median(s0, "error"="0.01") from root.test
+select median(s1, "error"="0.01") from root.test
```
Output series:
```
+-----------------------------+------------------------------------+
-| Time|median(root.test.s0, "error"="0.01")|
+| Time|median(root.test.s1, "error"="0.01")|
+-----------------------------+------------------------------------+
-|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+|1970-01-01T08:00:00.000+08:00| 0.0|
+-----------------------------+------------------------------------+
```
@@ -1349,52 +1338,35 @@ This function is used to calculate partial
autocorrelation of input series by so
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
SQL for query:
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
Output series:
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
### Percentile
@@ -1427,37 +1399,31 @@ The function is used to compute the exact or
approximate percentile of a numeric
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
+Total line number = 20
```
SQL for query:
@@ -1469,11 +1435,11 @@ select percentile(s0, "rank"="0.2", "error"="0.01")
from root.test
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|percentile(root.test.s0, "rank"="0.2",
"error"="0.01")|
-+-----------------------------+------------------------------------------------------+
-|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
```
### Quantile
@@ -1506,53 +1472,36 @@ The function is used to compute the approximate
quantile of a numeric time serie
Input series:
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
SQL for query:
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
Output series:
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
diff --git a/src/zh/UserGuide/Master/Reference/UDF-Libraries.md
b/src/zh/UserGuide/Master/Reference/UDF-Libraries.md
index f5cd4d21..a378e843 100644
--- a/src/zh/UserGuide/Master/Reference/UDF-Libraries.md
+++ b/src/zh/UserGuide/Master/Reference/UDF-Libraries.md
@@ -1000,52 +1000,47 @@ create function mad as
'org.apache.iotdb.library.dprofile.UDAFMad'
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
............
-Total line number = 10000
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select mad(s0) from root.test
+select mad(s1) from root.test
```
输出序列：
```
-+-----------------------------+------------------+
-| Time| mad(root.test.s0)|
-+-----------------------------+------------------+
-|1970-01-01T08:00:00.000+08:00|0.6806197166442871|
-+-----------------------------+------------------+
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
```
##### 近似查询
@@ -1055,16 +1050,16 @@ select mad(s0) from root.test
输入序列同上，用于查询的 SQL 语句如下：
```sql
-select mad(s0, "error"="0.01") from root.test
+select mad(s1, "error"="0.01") from root.test
```
输出序列：
```
+-----------------------------+---------------------------------+
-| Time|mad(root.test.s0, "error"="0.01")|
+| Time|mad(root.test.s1, "error"="0.01")|
+-----------------------------+---------------------------------+
-|1970-01-01T08:00:00.000+08:00| 0.6806616245859518|
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
+-----------------------------+---------------------------------+
```
@@ -1096,51 +1091,45 @@ create function median as
'org.apache.iotdb.library.dprofile.UDAFMedian'
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select median(s0, "error"="0.01") from root.test
+select median(s1, "error"="0.01") from root.test
```
输出序列：
```
+-----------------------------+------------------------------------+
-| Time|median(root.test.s0, "error"="0.01")|
+| Time|median(root.test.s1, "error"="0.01")|
+-----------------------------+------------------------------------+
-|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+|1970-01-01T08:00:00.000+08:00| 0.0|
+-----------------------------+------------------------------------+
```
@@ -1355,52 +1344,35 @@ create function pacf as
'org.apache.iotdb.library.dprofile.UDTFPACF'
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
用于查询的 SQL 语句：
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
输出序列：
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
### Percentile
@@ -1480,8 +1452,54 @@ select percentile(s0, "rank"="0.2", "error"="0.01") from
root.test
+-----------------------------+------------------------------------------------------+
|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
+-----------------------------+------------------------------------------------------+
+```输入序列：
+
+```
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
+............
+Total line number = 20
+```
+
+用于查询的 SQL 语句：
+
+```sql
+select percentile(s1, "rank"="0.2", "error"="0.01") from root.test
```
+输出序列：
+
+```
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
+```
+
+
### Quantile
#### 注册语句
@@ -1513,53 +1531,36 @@ create function quantile as
'org.apache.iotdb.library.dprofile.UDAFQuantile'
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
用于查询的 SQL 语句：
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
输出序列：
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
diff --git a/src/zh/UserGuide/V1.2.x/Reference/UDF-Libraries.md
b/src/zh/UserGuide/V1.2.x/Reference/UDF-Libraries.md
index 005865d5..6a29b4c3 100644
--- a/src/zh/UserGuide/V1.2.x/Reference/UDF-Libraries.md
+++ b/src/zh/UserGuide/V1.2.x/Reference/UDF-Libraries.md
@@ -1055,6 +1055,135 @@ select median(s0, "error"="0.01") from root.test
+-----------------------------+------------------------------------+
|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+-----------------------------+------------------------------------+
+```输入序列：
+
+```
++-----------------------------+------------+
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
+```
+
+用于查询的 SQL 语句：
+
+```sql
+select mad(s1) from root.test
+```
+
+输出序列：
+
+```
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
+```
+
+##### 近似查询
+
+当`error`参数取值不为 0 时，本函数计算近似绝对中位差。
+
+输入序列同上，用于查询的 SQL 语句如下：
+
+```sql
+select mad(s1, "error"="0.01") from root.test
+```
+
+输出序列：
+
+```
++-----------------------------+---------------------------------+
+| Time|mad(root.test.s1, "error"="0.01")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
++-----------------------------+---------------------------------+
+```
+
+### Median
+
+#### 函数简介
+
+本函数用于计算单列数值型数据的精确或近似中位数。中位数是顺序排列的一组数据中居于中间位置的数；当序列有偶数个时，中位数为中间二者的平均数。
+
+**函数名：** MEDIAN
+
+**输入序列：** 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE
+
+**参数：**
+
++ `error`：近似中位数的基于排名的误差百分比，取值范围 [0,1)，默认值为 0。如当`error`=0.01 时，计算出的中位数的真实排名百分比在
0.49~0.51 之间。当`error`=0 时，计算结果为精确中位数。
+
+**输出序列：** 输出单个序列，类型为 DOUBLE，序列仅包含一个时间戳为 0、值为中位数的数据点。
+
+#### 使用示例
+
+输入序列：
+
+```
++-----------------------------+------------+
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+............
+Total line number = 20
+```
+
+用于查询的 SQL 语句：
+
+```sql
+select median(s1, "error"="0.01") from root.test
+```
+
+输出序列：
+
+```
++-----------------------------+------------------------------------+
+| Time|median(root.test.s1, "error"="0.01")|
++-----------------------------+------------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+------------------------------------+
```
### MinMax
@@ -1303,54 +1432,38 @@ select mvavg(s1, "window"="3") from root.test
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
用于查询的 SQL 语句：
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
输出序列：
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
+
### Percentile
#### 函数简介
@@ -1375,53 +1488,48 @@ select pacf(s1, "lag"="5") from root.test
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select percentile(s0, "rank"="0.2", "error"="0.01") from root.test
+select percentile(s1, "rank"="0.2", "error"="0.01") from root.test
```
输出序列：
```
-+-----------------------------+------------------------------------------------------+
-| Time|percentile(root.test.s0, "rank"="0.2",
"error"="0.01")|
-+-----------------------------+------------------------------------------------------+
-|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
```
### Quantile
@@ -1449,53 +1557,36 @@ select percentile(s0, "rank"="0.2", "error"="0.01")
from root.test
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
用于查询的 SQL 语句：
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
输出序列：
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
@@ -1546,6 +1637,7 @@ select period(s1) from root.test.d3
+-----------------------------+-----------------------+
```
+
### QLB
#### 函数简介
diff --git a/src/zh/UserGuide/latest/Reference/UDF-Libraries.md
b/src/zh/UserGuide/latest/Reference/UDF-Libraries.md
index 05385e02..178da516 100644
--- a/src/zh/UserGuide/latest/Reference/UDF-Libraries.md
+++ b/src/zh/UserGuide/latest/Reference/UDF-Libraries.md
@@ -1000,52 +1000,47 @@ create function mad as
'org.apache.iotdb.library.dprofile.UDAFMad'
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
++-----------------------------+------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
............
-Total line number = 10000
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select mad(s0) from root.test
+select mad(s1) from root.test
```
输出序列：
```
-+-----------------------------+------------------+
-| Time| mad(root.test.s0)|
-+-----------------------------+------------------+
-|1970-01-01T08:00:00.000+08:00|0.6806197166442871|
-+-----------------------------+------------------+
++-----------------------------+---------------------------------+
+| Time|median(root.test.s1, "error"="0")|
++-----------------------------+---------------------------------+
+|1970-01-01T08:00:00.000+08:00| 0.0|
++-----------------------------+---------------------------------+
```
##### 近似查询
@@ -1055,16 +1050,16 @@ select mad(s0) from root.test
输入序列同上，用于查询的 SQL 语句如下：
```sql
-select mad(s0, "error"="0.01") from root.test
+select mad(s1, "error"="0.01") from root.test
```
输出序列：
```
+-----------------------------+---------------------------------+
-| Time|mad(root.test.s0, "error"="0.01")|
+| Time|mad(root.test.s1, "error"="0.01")|
+-----------------------------+---------------------------------+
-|1970-01-01T08:00:00.000+08:00| 0.6806616245859518|
+|1970-01-01T08:00:00.000+08:00| 0.9900000000000001|
+-----------------------------+---------------------------------+
```
@@ -1096,51 +1091,45 @@ create function median as
'org.apache.iotdb.library.dprofile.UDAFMedian'
```
+-----------------------------+------------+
-| Time|root.test.s0|
+| Time|root.test.s1|
+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
-............
-Total line number = 10000
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+------------+
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select median(s0, "error"="0.01") from root.test
+select median(s1, "error"="0.01") from root.test
```
输出序列：
```
+-----------------------------+------------------------------------+
-| Time|median(root.test.s0, "error"="0.01")|
+| Time|median(root.test.s1, "error"="0.01")|
+-----------------------------+------------------------------------+
-|1970-01-01T08:00:00.000+08:00| 1.021884560585022|
+|1970-01-01T08:00:00.000+08:00| 0.0|
+-----------------------------+------------------------------------+
```
@@ -1354,54 +1343,38 @@ create function pacf as
'org.apache.iotdb.library.dprofile.UDTFPACF'
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s1|
-+-----------------------------+------------+
-|2019-12-27T00:00:00.000+08:00| 5.0|
-|2019-12-27T00:05:00.000+08:00| 5.0|
-|2019-12-27T00:10:00.000+08:00| 5.0|
-|2019-12-27T00:15:00.000+08:00| 5.0|
-|2019-12-27T00:20:00.000+08:00| 6.0|
-|2019-12-27T00:25:00.000+08:00| 5.0|
-|2019-12-27T00:30:00.000+08:00| 6.0|
-|2019-12-27T00:35:00.000+08:00| 6.0|
-|2019-12-27T00:40:00.000+08:00| 6.0|
-|2019-12-27T00:45:00.000+08:00| 6.0|
-|2019-12-27T00:50:00.000+08:00| 6.0|
-|2019-12-27T00:55:00.000+08:00| 5.982609|
-|2019-12-27T01:00:00.000+08:00| 5.9652176|
-|2019-12-27T01:05:00.000+08:00| 5.947826|
-|2019-12-27T01:10:00.000+08:00| 5.9304347|
-|2019-12-27T01:15:00.000+08:00| 5.9130435|
-|2019-12-27T01:20:00.000+08:00| 5.8956523|
-|2019-12-27T01:25:00.000+08:00| 5.878261|
-|2019-12-27T01:30:00.000+08:00| 5.8608694|
-|2019-12-27T01:35:00.000+08:00| 5.843478|
-............
-Total line number = 18066
++-----------------------------+---------------+
+| Time|root.test.d1.s1|
++-----------------------------+---------------+
+|2020-01-01T00:00:01.000+08:00| 1|
+|2020-01-01T00:00:02.000+08:00| NaN|
+|2020-01-01T00:00:03.000+08:00| 3|
+|2020-01-01T00:00:04.000+08:00| NaN|
+|2020-01-01T00:00:05.000+08:00| 5|
++-----------------------------+---------------+
```
用于查询的 SQL 语句：
```sql
-select pacf(s1, "lag"="5") from root.test
+select pacf(s1, "lag"="5") from root.test.d1
```
输出序列：
```
-+-----------------------------+-----------------------------+
-| Time|pacf(root.test.s1, "lag"="5")|
-+-----------------------------+-----------------------------+
-|2019-12-27T00:00:00.000+08:00| 1.0|
-|2019-12-27T00:05:00.000+08:00| 0.3528915091942786|
-|2019-12-27T00:10:00.000+08:00| 0.1761346122516304|
-|2019-12-27T00:15:00.000+08:00| 0.1492391973294682|
-|2019-12-27T00:20:00.000+08:00| 0.03560059645868398|
-|2019-12-27T00:25:00.000+08:00| 0.0366222998995286|
-+-----------------------------+-----------------------------+
++-----------------------------+--------------------------------+
+| Time|pacf(root.test.d1.s1, "lag"="5")|
++-----------------------------+--------------------------------+
+|2020-01-01T00:00:01.000+08:00| 1.0|
+|2020-01-01T00:00:02.000+08:00| -0.5744680851063829|
+|2020-01-01T00:00:03.000+08:00| 0.3172297297297296|
+|2020-01-01T00:00:04.000+08:00| -0.2977686586304181|
+|2020-01-01T00:00:05.000+08:00| -2.0609033521065867|
++-----------------------------+--------------------------------+
```
+
### Percentile
#### 注册语句
@@ -1432,53 +1405,48 @@ create function percentile as
'org.apache.iotdb.library.dprofile.UDAFPercentile'
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test2.s1|
++-----------------------------+-------------+
+|1970-01-01T08:00:00.100+08:00| 0.0|
+|1970-01-01T08:00:00.200+08:00| 0.0|
+|1970-01-01T08:00:00.300+08:00| 1.0|
+|1970-01-01T08:00:00.400+08:00| -1.0|
+|1970-01-01T08:00:00.500+08:00| 0.0|
+|1970-01-01T08:00:00.600+08:00| 0.0|
+|1970-01-01T08:00:00.700+08:00| -2.0|
+|1970-01-01T08:00:00.800+08:00| 2.0|
+|1970-01-01T08:00:00.900+08:00| 0.0|
+|1970-01-01T08:00:01.000+08:00| 0.0|
+|1970-01-01T08:00:01.100+08:00| 1.0|
+|1970-01-01T08:00:01.200+08:00| -1.0|
+|1970-01-01T08:00:01.300+08:00| -1.0|
+|1970-01-01T08:00:01.400+08:00| 1.0|
+|1970-01-01T08:00:01.500+08:00| 0.0|
+|1970-01-01T08:00:01.600+08:00| 0.0|
+|1970-01-01T08:00:01.700+08:00| 10.0|
+|1970-01-01T08:00:01.800+08:00| 2.0|
+|1970-01-01T08:00:01.900+08:00| -2.0|
+|1970-01-01T08:00:02.000+08:00| 0.0|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 20
```
用于查询的 SQL 语句：
```sql
-select percentile(s0, "rank"="0.2", "error"="0.01") from root.test
+select percentile(s1, "rank"="0.2", "error"="0.01") from root.test
```
输出序列：
```
-+-----------------------------+------------------------------------------------------+
-| Time|percentile(root.test.s0, "rank"="0.2",
"error"="0.01")|
-+-----------------------------+------------------------------------------------------+
-|2021-03-17T10:35:02.054+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+-------------------------------------------------------+
+| Time|percentile(root.test2.s1, "rank"="0.2",
"error"="0.01")|
++-----------------------------+-------------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
-1.0|
++-----------------------------+-------------------------------------------------------+
```
### Quantile
@@ -1512,53 +1480,36 @@ create function quantile as
'org.apache.iotdb.library.dprofile.UDAFQuantile'
输入序列：
```
-+-----------------------------+------------+
-| Time|root.test.s0|
-+-----------------------------+------------+
-|2021-03-17T10:32:17.054+08:00| 0.5319929|
-|2021-03-17T10:32:18.054+08:00| 0.9304316|
-|2021-03-17T10:32:19.054+08:00| -1.4800133|
-|2021-03-17T10:32:20.054+08:00| 0.6114087|
-|2021-03-17T10:32:21.054+08:00| 2.5163336|
-|2021-03-17T10:32:22.054+08:00| -1.0845392|
-|2021-03-17T10:32:23.054+08:00| 1.0562582|
-|2021-03-17T10:32:24.054+08:00| 1.3867859|
-|2021-03-17T10:32:25.054+08:00| -0.45429882|
-|2021-03-17T10:32:26.054+08:00| 1.0353678|
-|2021-03-17T10:32:27.054+08:00| 0.7307929|
-|2021-03-17T10:32:28.054+08:00| 2.3167255|
-|2021-03-17T10:32:29.054+08:00| 2.342443|
-|2021-03-17T10:32:30.054+08:00| 1.5809103|
-|2021-03-17T10:32:31.054+08:00| 1.4829416|
-|2021-03-17T10:32:32.054+08:00| 1.5800357|
-|2021-03-17T10:32:33.054+08:00| 0.7124368|
-|2021-03-17T10:32:34.054+08:00| -0.78597564|
-|2021-03-17T10:32:35.054+08:00| 1.2058644|
-|2021-03-17T10:32:36.054+08:00| 1.4215064|
-|2021-03-17T10:32:37.054+08:00| 1.2808295|
-|2021-03-17T10:32:38.054+08:00| -0.6173715|
-|2021-03-17T10:32:39.054+08:00| 0.06644377|
-|2021-03-17T10:32:40.054+08:00| 2.349338|
-|2021-03-17T10:32:41.054+08:00| 1.7335888|
-|2021-03-17T10:32:42.054+08:00| 1.5872132|
++-----------------------------+-------------+
+| Time|root.test1.s1|
++-----------------------------+-------------+
+|2021-03-17T10:32:17.054+08:00| 7|
+|2021-03-17T10:32:18.054+08:00| 15|
+|2021-03-17T10:32:19.054+08:00| 36|
+|2021-03-17T10:32:20.054+08:00| 39|
+|2021-03-17T10:32:21.054+08:00| 40|
+|2021-03-17T10:32:22.054+08:00| 41|
+|2021-03-17T10:32:23.054+08:00| 20|
+|2021-03-17T10:32:24.054+08:00| 18|
++-----------------------------+-------------+
............
-Total line number = 10000
+Total line number = 8
```
用于查询的 SQL 语句：
```sql
-select quantile(s0, "rank"="0.2", "K"="800") from root.test
+select quantile(s1, "rank"="0.2", "K"="800") from root.test1
```
输出序列：
```
-+-----------------------------+------------------------------------------------------+
-| Time|quantile(root.test.s0, "rank"="0.2", "K"="800")|
-+-----------------------------+------------------------------------------------------+
-|1970-01-01T08:00:00.000+08:00|
0.1801469624042511|
-+-----------------------------+------------------------------------------------------+
++-----------------------------+------------------------------------------------+
+| Time|quantile(root.test1.s1, "rank"="0.2",
"K"="800")|
++-----------------------------+------------------------------------------------+
+|1970-01-01T08:00:00.000+08:00|
7.000000000000001|
++-----------------------------+------------------------------------------------+
```
### Period
