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:
1. Another Whiteboard Walkthrough by Neeraja “Overview Apache Drill’s Query Execution Capabilities” https://www.mapr.com/blog/big-data-sql-overview-apache-drill-query-execution-capabilities-whiteboard-walkthrough
2. “Apache Drill SQL Queries on Parquet Data” Whiteboard Walkthrough video by Parth Chandra https://www.mapr.com/blog/apache-drill-sql-queries-parquet-data-whiteboard-walkthrough
3. “Sequel Query on Mixed Schema Data Using Apache Drill” blog post by Ellen Friedman https://www.mapr.com/blog/sql-query-mixed-schema-data-using-apache-drill
4. Free download MapR Apache Drill sandbox https://www.mapr.com/products/mapr-sandbox-hadoop/download-sandbox-drill