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)

Reply via email to