Impala for Business Intelligence 교육 과정

Course Code

Imp

Duration

21 hours (usually 3 days including breaks)

Requirements

  • knowledge of SQL

Overview

Cloudera Impala 는 Apache Hadoop 클러스터 용 오픈 소스 대규모 병렬 처리 (MPP) SQL 쿼리 엔진입니다.

Impala 는 사용자가 데이터 이동이나 변환없이 Hadoop Distributed File System 및 Apache Hbase에 저장된 데이터에 지연이 적은 SQL 쿼리를 SQL 수 있도록합니다.

청중

이 과정은 Business Intelligence 또는 SQL 도구를 통해 Hadoop 저장된 데이터를 분석하는 분석가 및 데이터 과학자를 대상으로합니다.

이 과정이 끝나면 대표단은

  • ImpalaHadoop 클러스터에서 의미있는 정보를 추출합니다.
  • Impala SQL Dialect에서 Business Intelligence 를 용이하게하는 특정 프로그램을 작성하십시오.
  • Impala 문제를 해결하십시오.

Machine Translated

Course Outline

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

 

 

회원 평가

★★★★★
★★★★★

Related Categories

고객 회사

is growing fast!

We are looking to expand our presence in South Korea!

As a Business Development Manager you will:

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