Impala for Business Intelligence Treningskurs

Kurskode

Imp

Varighet

21 timer (vanligvis 3 dag inkludert pauser)

Krav

  • knowledge of SQL

Oversikt

Cloudera Impala er en open source massively parallel processing (MPP) SQL spørringsmotor for Apache Hadoop klynger.

Impala gjør det mulig for brukere å sende ut SQL spørsmål med lav latens til data som er lagret i Hadoop Distribuerte filsystem og Apache Hbase uten å kreve databevegelse eller transformasjon.

Publikum

Dette kurset er rettet mot analytikere og dataforskere som utfører analyse av data som er lagret i Hadoop via Business Intelligence eller SQL verktøy.

Etter dette kurset vil delegatene kunne

  • Trekk ut meningsfull informasjon fra Hadoop klynger med Impala .
  • Skriv spesifikke programmer for å lette Business Intelligence i Impala SQL Dialect.
  • Feilsøk Impala .

Machine Translated

Kursplan

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

 

 

Testimonials

★★★★★
★★★★★

Related Categories

Kursrabatter

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

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