Audience Profile

This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators.

Prerequisites

Some knowledge of SQL is assumed, as is basic Linux command-line familiarity.

At Course Completion

Through instructor-led discussion and interactive, hands-on exercises, participants will navigate the ecosystem, learning how to:

• Use Apache Hive and Apache Impala to access data through queries
• Identify distinctions between Hive and Impala, such as differences in syntax, data formats, and supported features
• Write and execute queries that use functions, aggregate functions, and subqueries
• Use joins and unions to combine datasets
• Create, modify, and delete tables, views, and databases
• Load data into tables and store query results
• Select file formats and develop partitioning schemes for better performance
• Use analytic and windowing functions to gain insight into their data
• Store and query complex or nested data structures
• Process and analyze semi-structured and unstructured data
• Optimize and extend the capabilities of Hive and Impala
• Determine whether Hive, Impala, an RDBMS, or a mix of these is the best choice for a given task
• Utilize the benefits of CDP Public Cloud Data Warehouse