[DRILL-5429] Improve query performance for MapR DB JSON Tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.11.0
• Component/s: Query Planning & Optimization, Storage - MapRDB
• Labels: ready-to-commit
• Assignee: Padma Penumarthy
• Reporter: Padma Penumarthy
• Reviewer: Gautam Parai
• Created: 11/Apr/17 23:12
• Updated: 13/May/17 17:42
• Resolved: 13/May/17 17:42

Description

For MapR DB JSON Tables, cache (per query) and reuse table and tabletInfo, instead of fetching the same information multiple times from DB server. Also, getting tableStats is an expensive operation. We can avoid doing that and instead, get total rowCount from tabletInfo instead.

Issue Links

• links to: GitHub Pull Request #817