Cloudera - Managing Big Data in Clusters and Cloud Storage 

Welcome to the Course

Browsing Tables with Hue

Browsing Tables with SQL Utility Statements

Browsing HDFS with the Hue File Browser

Browsing HDFS from the Command Line

Understanding S3 and Other Cloud Storage Platforms

Browsing S3 Buckets from the Command Line

Week 2: Defining Databases, Tables, and Columns

Week 2 Introduction

Introduction to the CREATE TABLE Statement

Using Different Schemas on the Same Data

Specifying TBLPROPERTIES

Examining, Modifying, and Removing Tables

Hive and Impala Interoperability

Impala Metadata Refresh

Week 3: Data Types and File Types

Week 3 Introduction

Overview of Data Types

Choosing the Right Data Types

Overview of File Types

Choosing the Right File Types

Week 4: Managing Datasets in Clusters and Cloud Storage

Week 4 Introduction

Refresh Impala's Metadata Cache after Loading Data

Loading Files into HDFS with Hue's Table Browser

Loading Files into HDFS with Hue's File Browser

Loading Files into HDFS from the Command Line

Loading Files into S3 from the Command Line

Using Hive and Impala to Load Data into Tables

Conclusion

Week 5: Optimizing Hive and Impala (Honors)

Week 5 Introduction

What to Do When Queries Are Too Complex

What to Do When Queries Take Too Long

When to Use Table Partitioning

When to Use Complex Columns

File Systems versus Storage Engines