Impala for Business Intelligence培训

课程编码

Imp

课程时长

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

要求

  • knowledge of SQL

课程概览

Cloudera Impala是Apache Hadoop集群的开源大规模并行处理(MPP) SQL查询引擎。

Impala使用户能够向存储在Hadoop分布式文件系统和Apache Hbase中的数据发出低延迟SQL查询,而无需数据移动或转换。

听众

本课程面向分析师和数据科学家,通过Business IntelligenceSQL工具对存储在Hadoop数据进行分析。

在此课程结束后,代表们将能够

  • 使用ImpalaHadoop集群中提取有意义的信息。
  • 编写特定程序以便在Impala SQL Dialect中实现Business Intelligence
  • Impala故障排除。

Machine Translated

课程大纲

Introduction to Impala

  • What is Impala?
  • How Impala Differs from Relational Databases
  • Limitations and Future Directions
  • Using the Impala Shell
  • The Impala Daemon, Statestore and Catalogue service

Loading Impala

  • Explore a New Impala Instance
  • Load CSV Data from Local Files
  • Point an Impala Table at Existing Data Files

Analyzing Data with Impala

  • Describe the Impala Table
  • Basic Syntax and Querying
  • Data Types
  • Filtering, Sorting, and Limiting Results
  • Joining and Grouping Data
  • Data Loading and Querying Examples
  • Improving Impala Performance
  • How Impala works with Hadoop file formats
  • Hands-On Exercise: Interactive Analysis with Impala

Programming Impala Applications

  • Overview of the Impala SQL Dialect
  • Overview of Impala Programming Interfaces

Troubleshooting Impala

  • Troubleshooting Impala SQL Syntax Issues
  • Troubleshooting I/O Capacity Problems
  • Impala Web User Interface for Debugging

 

 

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

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

我们的客户

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!

该网站在其他国家/地区