Apache Drill Query Optimization培训

课程编码

apachedrillqueryoptim

课程时长

7 小时 通常来说是1天,包括中间休息。

要求

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

课程概览

Apache Drill是一个无架构,分布式,内存中的柱状SQL查询引擎,适用于Hadoop ,No SQL和其他云和文件存储系统。 Apache Drill的强大之处在于它能够使用单个查询连接来自多个数据存储的数据。 Apache Drill支持众多无SQL数据库和文件系统,包括HBase的, MongoDB ,MAPR-DB,HDFS,MAPR-FS,亚马逊S3, Azure Blob存储, Go抛媚眼云存储, Swift ,NAS和本地文件。 Apache DrillGo ogle Dremel系统的开源版本,可作为名为Go ogle BigQuery的基础结构服务提供。

在这个由讲师指导的实时培训中,参与者将学习如何优化和调试Apache Drill以提高对非常大的数据集的查询性能。本课程首先介绍Apache Drill与其他交互式数据分析工具之间的架构概述和功能比较。然后,参与者将逐步完成一系列交互式实践练习,包括安装,配置,性能评估,查询优化,数据分区以及在实验室环境中调试Apache Drill实例。

在培训结束时,参与者将能够:

  • 安装和配置Apache Drill
  • 了解Apache Drill的架构和功能
  • 了解Apache Drill如何接收和执行查询
  • 优化分布式SQL执行的钻取查询
  • 调试Apache Drill

听众

  • 开发商
  • 系统管理员
  • 数据分析师

课程形式

  • 部分讲座,部分讨论,练习和繁重的实践练习

笔记

  • 要申请本课程的定制培训,请联系我们安排。

Machine Translated

课程大纲

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

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

该网站在其他国家/地区