You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2023/05/17 08:02:00 UTC
[jira] [Created] (IOTDB-5891) Fill null value order by query meet exceptions
xiaozhihong created IOTDB-5891:
----------------------------------
Summary: Fill null value order by query meet exceptions
Key: IOTDB-5891
URL: https://issues.apache.org/jira/browse/IOTDB-5891
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Affects Versions: master
Reporter: xiaozhihong
Assignee: yang caiyin
Branch : Master
commit ab43262e3974574334ca7ff131e8d11e7f5da69f
Fill null value order by query meet exceptions.
{code:java}
IoTDB> select s1, s3 from root.sg.d1 where time >= 1 and time <= 10 fill(previous);
+-----------------------------+-------------+-------------+
| Time|root.sg.d1.s1|root.sg.d1.s3|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| 1| 1.1|
|1970-01-01T08:00:00.002+08:00| 2| 2.2|
|1970-01-01T08:00:00.003+08:00| 3| 2.2|
|1970-01-01T08:00:00.004+08:00| 4| 4.4|
|1970-01-01T08:00:00.005+08:00| 5| 5.5|
|1970-01-01T08:00:00.006+08:00| 6| 5.5|
|1970-01-01T08:00:00.007+08:00| 7| 100.1|
|1970-01-01T08:00:00.008+08:00| 55| 0.0|
|1970-01-01T08:00:00.009+08:00| -15| 0.0|
|1970-01-01T08:00:00.010+08:00| 0| 10.1|
+-----------------------------+-------------+-------------+
Total line number = 10
It costs 0.014s
IoTDB> select s1, s3 from root.sg.d1 where time >= 1 and time <= 10 fill(previous) order by s2,time desc align by device;
Msg: 301: There is not enough memory to execute current fragment instance, current remaining free memory is 122812237, estimated memory usage for current fragment instance is 158203904
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)