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)