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 Taiwan!

As a Business Development Manager you will:

  • expand business in Taiwan
  • 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!