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)