In this week's Whiteboard Walkthrough video, Neeraja Rentachintala, Senior Director of Product Management at MapR Technologies, explains how Apache Drill optimization achieves interactive performance for low latency SQL queries on very large data sets when working with familiar BI tools such as Tableau, Microstrategy or Qlikview and includes techniques used for successful optimization using Drill in production. Neeraja describes Drill optimization capabilities based on Apache Calcite that include projection pruning, filter push down, partition pruning, cost-based optimization and meta-data caching.
For more on Apache Drill go to:
3. “ Big Data SQL: Overview of Apache Drill Query Execution Capabilities" video by Neeraja
4. Apache Drill SQL Queries on Parquet Data | Whiteboard Walkthrough video by Parth Chandra
5. Read SQL Query on Mixed Schema Data Using Apache Drill | MapR blog post by Ellen Friedman