You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2023/08/14 06:29:00 UTC
[jira] [Created] (IOTDB-6112) Limit & Offset push down doesn't take effect while there exist time filter
Yuan Tian created IOTDB-6112:
--------------------------------
Summary: Limit & Offset push down doesn't take effect while there exist time filter
Key: IOTDB-6112
URL: https://issues.apache.org/jira/browse/IOTDB-6112
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Reporter: Yuan Tian
Assignee: Yuan Tian
Attachments: image-2023-08-14-14-27-17-784.png, image-2023-08-14-14-28-08-409.png
We found that if we add `where time > 0`, the sql will be much slower which means the limit & offset filter push down doesn't take effect.
!image-2023-08-14-14-28-08-409.png!
!image-2023-08-14-14-27-17-784.png!
However, when I remove the `where time > 0`, time costs will be about 0.2s
--
This message was sent by Atlassian Jira
(v8.20.10#820010)