[DRILL-6640] Drill takes long time in planning when there are large number of files in views/tables DFS parent directory

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Arjun
• Reporter: Arjun
• Reviewer: Hanumath Rao Maduri
• Created: 26/Jul/18 18:25
• Updated: 30/Aug/18 21:46
• Resolved: 30/Aug/18 21:46

Description

When Drill is used for querying views/ tables, the query planning time increases as the number of files in views/tables parent directory increases. This becomes unacceptably long with complex queries.

This is caused by globStatus operation on view files using GLOB to retrieve view file status. This can be improved by avoiding the usage of GLOB pattern for Drill metadata files like view files.

Issue Links

• links to: GitHub Pull Request #1405