BigData SQL Hive

BigData SQL Hive

This training is aimed at developers and covers the full stack of technical features, architecture and performance tuning. Apache Hive supports analysis of large datasets stored in Hadoop's HDFS and compatible file systems and it provides an SQL-like language with schema on read and transparently converts queries to map/reduce.

Czas trwania
8 hours
Typ kursu
Online
Język
English
Czas trwania
8 hours
Lokalizacja
Online
Język
English
Kod
EAS-016
Harmonogram i ceny
-
€ 300 *
Szkolenie dla #uczestników# lub większej liczby osób? Dostosuj treningi dla Twoich konkretnych potrzeb
BigData SQL Hive
Czas trwania
8 hours
Lokalizacja
Online
Język
English
Kod
EAS-016
Harmonogram i ceny
-
€ 300 *
Szkolenie dla #uczestników# lub większej liczby osób? Dostosuj treningi dla Twoich konkretnych potrzeb

Opis

This training is aimed at developers and covers the full stack of technical features, architecture and performance tuning. Apache Hive supports analysis of large datasets stored in Hadoop's HDFS and compatible file systems and it provides an SQL-like language with schema on read and transparently converts queries to map/reduce. Other features of Hive include:

  • Indexing to provide acceleration
  • Different storage types such as plain text, RCFile, HBase, ORC, and others.
  • Metadata storage in an RDBMS
  • Operating on compressed data stored into the Hadoop ecosystem
  • Built-in user defined functions (UDFs) to manipulate dates, strings, and other data-mining tools
  • SQL-like queries (HiveQL), which are implicitly converted into MapReduce
certificate
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat

Cele

  • Developing expertise in the area of Big Data
  • Data modal design in Hive
  • Developing HSQL scripts
  • Practical experience in HSQL queries and performance tuning

Grupa docelowa

  • Developers
  • QA
  • Analysts

Warunki wstępne

  • Hadoop fundamentals
  • ANSI SQL 92

Plan działania

  • What is Hive
  • Architecture
  • Hive Authorization Options
  • Transactions
  • Data Types
  • “Select” Queries
  • DML / Export / Import
  • Hive UDFs types
  • Indexes
  • Windowing and Analytics Functions
  • Performance tuning

"TYPE"html";}

Harmonogram i ceny
10:00-13:00
Kod: EAS-016
Lokalizacja: Online
Czas trwania: 8 hours
Język: English
Czas: 10:00-13:00
€ 300 *
10:00-13:00
Kod: EAS-016
Lokalizacja: Online
Czas trwania: 8 hours
Język: English
Czas: 10:00-13:00
. . .
*
Nadal masz pytania?
Połącz sięz nami