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.
8 hours
Online
English
EAS-016
BigData SQL Hive
Sign Up
Duration
8 hours
Location
Online
Language
English
Code
EAS-016
Schedule and prices
€ 250
Training for 7-8 or more people? Customize trainings for your specific needs
BigData SQL Hive
Sign Up
Duration
8 hours
Location
Online
Language
English
Code
EAS-016
Schedule and prices
€ 250
Training for 7-8 or more people? Customize trainings for your specific needs

Description

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
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

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

Target Audience

  • Developers
  • QA
  • Analysts

Prerequisites

  • Hadoop fundamentals
  • ANSI SQL 92

Roadmap

  • 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
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
+
Courses you may be interested in
Data warehouse – modeling and design
This is an introductory course that covers the basics of data warehouse.
Cassandra for Developers
Cassandra is an open source distributed, fault-tolerant, horizontally scalable, non-relational database management system featuring very fast writes and simple fast reads.
BigData SQL Impala
This is a training about Impala for developers covering the full stack of technical features, architecture and performance tuning. Impala supports analysis of large datasets stored in HDFS and compatible file systems, providing an SQL-like language.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.