[DRILL-6248] Support pushdown into System Table

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Kunal Khatua
• Reviewer: Kunal Khatua
• Created: 14/Mar/18 19:00
• Updated: 26/Mar/18 12:01
• Resolved: 26/Mar/18 11:53

Description

When querying a profile store, we fetch all the records before applying a limit.

select * from sys.profiles limit 1

For a test scenario with 120K+ profiles in the store, a

select count(*) from sys.profiles

took 90 minutes.

Issue Links

• links to: GitHub Pull Request #1183