You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "Steve Yurong Su (Jira)" <ji...@apache.org> on 2022/02/23 11:59:00 UTC

[jira] [Created] (IOTDB-2596) UDF: range detection function

Steve Yurong Su created IOTDB-2596:
--------------------------------------

             Summary: UDF: range detection function
                 Key: IOTDB-2596
                 URL: https://issues.apache.org/jira/browse/IOTDB-2596
             Project: Apache IoTDB
          Issue Type: Wish
          Components: Core/Query
            Reporter: Steve Yurong Su


input: a time series (type: INT32, INT64, FLOAT or DOUBLE)

output: a time series (type: BOOLEAN)

 

parameters：

upper (double) 

lower (double) 

lower should be smaller or equals than upper

if lower <= value <= upper, output true, otherwise false

 

usage:

select s1, f(s1, 'lower'='1.5', 'upper'='3.0') from root.sg.d

 

 
||Time||root.sg.d.s1||f(root.sg.d.s1)||
|1|1.2|false|
|2|2.4|true|
|3|5.6|false|
|4|1.0|false|



--
This message was sent by Atlassian Jira
(v8.20.1#820001)