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/24 01:56:00 UTC

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

     [ https://issues.apache.org/jira/browse/IOTDB-2596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Yurong Su reassigned IOTDB-2596:
--------------------------------------

    Assignee: Xi Zhang

> 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
>            Assignee: Xi Zhang
>            Priority: Major
>
> 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)