SQL on Hadoop hands on session, part 1: Hive and Impala intro

Date: November 11, 2017, 9:30 – 13:30
Trainers: Felix Crisan, Valentina Crisan
Location: eSolutions Academy, Budişteanu Office Building, strada General Constantin Budişteanu Nr. 28C, etaj 1, Sector 1, Bucureşti.
Number of places: 15 3 places left
Price: 150 RON (including VAT)

Description:

They say SQL is the english language of the Big Data World, since almost everybody understands/knows its syntax. The aim of this workshop is to explain in SQL what kind of queries can be run on HDFS (the storage component of the Hadoop environment) – for batch and interactive queries – and, out of the several solutions available, to address and run hands on exercises on Apache Hive and Apache Impala and discuss the general performance that can be obtained. We will also discuss different file formats that can be used in order to get the best performance out of Hive and Impala, besides the types of operations/analytics that can be performed on HDFS data.

This workshop will be run completely on a cloud environment ( Cloudera’s Hadoop distribution on Bigstep cloud infrastructure).

The workshop is addressed to anyone with some SQL knowledge that would like to understand the use cases of Hadoop HDFS and the options available to query the data.

Agenda:

Hadoop environment overview: focus on HDFS
File formats supported
SQL on Hadoop options: overview of all solutions
Hive and Impala short overview (architecture, use cases, main differences)
Hands on session (we will use Cloudera Hadoop and Hue for running queries in Hive and Impala)
1. Input data in HDFS
2. Define tables metadata in Hive
3. Use Hive as ETL for file transformation from CSV to Avro, Parquet
4. Run analytical queries in Hive with different file formats
5. Run queries in Impala with different file formats

The price for the workshop is 150 RON (including VAT).

You can sign up here for this workshop:

1. Complete registration form:

Full name(required)

Email(required)

Company

For the training practical part it is required that you have your laptop with you .

For completing the registration for the training you need to go through the payment step, after submitting this form. Once completed you will receive a confirmation for the participation.

Terms and Conditions: the fee you pay is nonrefundable, unless the event is canceled/re-scheduled by the organizer. The ticket is possible to be transferred to another person, but is mandatory that you announce the organizer the new name minimum 2 days before the event. The organizer can re-schedule the event, if a minimum of 10 participants is not met. In these circumstances a new date will be provided for the event and the option to refund your money.

2. Payment (150 RON – incl. VAT) – please complete first the above form and then follow next link for completing the payment: http://mpy.ro/3suskaev

bigdata.ro

Romanian Big data communities

SQL on Hadoop hands on session, part 1: Hive and Impala intro

Description:

Agenda:

Description:

Agenda:

Share this:

Like this: