You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2022/01/11 10:30:00 UTC
[jira] [Commented] (IOTDB-2351) Support multiple WHERE time conditions in fill query (<,=,>,<=,>=)
[ https://issues.apache.org/jira/browse/IOTDB-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17472640#comment-17472640 ]
Haonan Hou commented on IOTDB-2351:
-----------------------------------
Does the following sql working?
{code:sql}
select s1 from root.sg.d2 where time < 5 fill(float [linear, 1ms, 1ms])
{code}
> Support multiple WHERE time conditions in fill query (<,=,>,<=,>=)
> ------------------------------------------------------------------
>
> Key: IOTDB-2351
> URL: https://issues.apache.org/jira/browse/IOTDB-2351
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Server
> Reporter: xiaozhihong
> Priority: Major
> Attachments: image-2022-01-11-15-20-06-452.png
>
>
> In the select into fill query, the where condition is not less than or equal to, only where time is equal to.
> Such as:
> (1)select s1 into fill_s1
> from root.sg.d2 where time = 10
> fill(float [linear, 1ms, 1ms]) ;
> (2) select s1 into fill_s1
> from root.sg.d2 where time < 5
> fill(float [linear, 1ms, 1ms]) ;
> !image-2022-01-11-15-20-06-452.png!
--
This message was sent by Atlassian Jira
(v8.20.1#820001)