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)