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

Posted to notifications@iotdb.apache.org by "Jialin Qiao (Jira)" <ji...@apache.org> on 2020/08/04 04:30:00 UTC

[jira] [Created] (IOTDB-828) Support Fill in raw data query

Jialin Qiao created IOTDB-828:
---------------------------------

             Summary: Support Fill in raw data query
                 Key: IOTDB-828
                 URL: https://issues.apache.org/jira/browse/IOTDB-828
             Project: Apache IoTDB
          Issue Type: New Feature
          Components: Core/Engine
            Reporter: Jialin Qiao


In some cases, the collected data belongs to different manufacturing batch, the manufacturing batch is stored as a field and only inserted when it changes.

 

When querying multiple series with the batch, some null will occurs. The following case contains two batch data.

 

time, s1, batch

1,  1,  1

2, 2,  null

3, 3,  null

4, 4,  2

5, 5,  null

6, 6,  null

In this case, we could support filling the null after aligning by time.

 

time, s1, batch

1,  1,  1

2, 2,  1

3, 3,  1

4, 4,  2

5, 5,  2

6, 6,  2

 

The related sql: select s1, batch from xxx fill()



--
This message was sent by Atlassian Jira
(v8.3.4#803005)