Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
How the open source ecosystem of big data tools addresses challenges not met by traditional RDBMSs
Hive and Impala syntax and data formats, including functions and subqueries
Create and use partitions and different file formats. Combining two or more datasets using JOIN or UNION, as appropriate
Process and analyze semi-structured and unstructured data. Techniques for optimizing Hive and Impala queries
How to determine whether Hive, Impala, an RDBMS, or a mix of these is best for a given task
Using Apache Hive and Apache Impala to provide SQL access to data
Create, modify, and delete tables, views, and databases; load data; and store results of queries
What analytic and windowing functions are, and how to use them. Store and query complex or nested data structures
Extending the capabilities of Hive and Impala using parameters, custom file formats and SerDes, and external scripts
Introduction to Apache Hadoop Fundamentals
Introduction to Apache Hive and Impala
Querying with Apache Hive and Impala
Common Operators and Built-In Functions
Data Storage
Data Storage and Performance
Working with Multiple Datasets
Analytic Functions and Windowing
Complex Data
Analyzing Text
Apache Hive Optimization
Apache Impala Optimization
Extending Apache Hive and Impala
Choosing the Best Tool for the Job