課程簡介

Introduction to Apache Drill

How does Apache Drill compare to Spark SQL, Hive and Impala?

Overview of Apache Drill Features and Architecture

  • Apache Drill Components

Understanding Apache Drill Queries

  • Query Execution Process

Performing SQL Queries

  • Connecting to the data source
  • Querying the data

Using the Drill Web Console

  • Query, Profiles, Storage, Metrics, Threads, and Options

Performance Optimization Strategy

  • Identifying the source of performance issues
  • Analyzing Query Plans and Profiles

Apache Drill Query Optimization

  • Optimizing a Query

Limiting the Data that Drill Reads

  • Partitioning the data (partition pruning)

Apache Drill Logging and Debugging

  • Analyzing Drill Error Messages
  • Configuring Log File Options

Troubleshooting Apache Drill

Summary and Conclusion

最低要求

  • An understanding of Hadoop, NoSQL, and other data storage concepts
  • A general understanding of SQL queries
  • Experience with Linux command line
 7 時間:

人數



每位參與者的報價

客戶評論 (5)

相關課程

Big Data Analytics for Telecom Regulators

14 時間:

Big Data Business Intelligence for Govt. Agencies

35 時間:

Big Data Architect

35 時間:

Big Data Business Intelligence for Criminal Intelligence Analysis

35 時間:

Programming with Big Data in R

21 時間:

Big Data Storage Solution - NoSQL

14 時間:

A Practical Introduction to Data Analysis and Big Data

35 時間:

Big Data & Database Systems Fundamentals

14 時間:

Big Data - Data Science

14 時間:

From Data to Decision with Big Data and Predictive Analytics

21 時間:

Data Science for Big Data Analytics

35 時間:

Machine Learning and Big Data

7 時間:

Sqoop and Flume for Big Data

7 時間:

Talend Big Data Integration

28 時間:

Administrator Training for Apache Hadoop

35 時間:

課程分類