Apache Drill SQL Query Optimization

Video created by aalvarez on Nov 18, 2016

    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. Explore Apache Drill Resources & Product Information

    2. Apache Drill Best Practices from the MapR Drill Team

    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

    6. Free  Download Sandbox with Drill | MapR 

     

    Or search:

    drill