Big Data Training & Consulting

Learn how to query your data and get the answers you need with Apache Hive. Use your existing SQL knowledge to query your data warehouse in a familiar manner.  This course is a great start for decision makers and data scientist looking to query data quickly and efficeintly.

Hive Training

Hive Overview

• Architecture and design
• Data types
• SQL support in Hive
• Creating Hive tables and querying
• Partitions
• Joins
• Text processing
• labs : various labs on processing data with Hive

DQL (Data Query Language) in Detail

• SELECT clause
• Column aliases
• Table aliases
• Date types and Date functions
• Group function
• Table joins
• JOIN clause
• UNION operator
• Nested queries
• Correlated sub-queries