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.

Durată
8 ore
Tipul de curs
Pe net
Limba
Engleză
Durată
8 ore
Locație
Pe net
Limba
Engleză
Cod
EAS-016
Program si preturi
-
€ 300 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice
BigData SQL Hive
Durată
8 ore
Locație
Online
Limba
English
Cod
EAS-016
Program si preturi
-
€ 300 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice

Descriere

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
certificat
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training

Obiective

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

Public țintă

  • Developers
  • QA
  • Analysts

Cerințe preliminare

  • Hadoop fundamentals
  • ANSI SQL 92

Foaia de parcurs

  • 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";}

Program si preturi
10:00-13:00
Cod: EAS-016
Locație: Online
Durată: 8 ore
Limba: English
Timp: 10:00-13:00
€ 300 *
10:00-13:00
Cod: EAS-016
Locație: Online
Durată: 8 ore
Limba: English
Timp: 10:00-13:00
. . .
*
Mai ai întrebări?
Conectați-văcu noi