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

Posted to dev@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2018/03/14 19:01:00 UTC

[jira] [Created] (DRILL-6248) Support pushdown into System Table

Kunal Khatua created DRILL-6248:
-----------------------------------

             Summary: Support pushdown into System Table
                 Key: DRILL-6248
                 URL: https://issues.apache.org/jira/browse/DRILL-6248
             Project: Apache Drill
          Issue Type: Improvement
            Reporter: Kunal Khatua


When querying a profile store, we fetch all the records before applying a limit.
{code:sql}
select * from sys.profiles limit 1
{code}

For a test scenario with 120K+ profiles in the store, a 
{code:sql}
select count(*) from sys.profiles
{code}
took 90 minutes.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)