Viewing & Querying Complex Data with Hive

Apache Hive 2.3.2    |    Beginner
  • 12 Videos | 1h 17m 54s
  • Includes Assessment
  • Earns a Badge
Likes 26 Likes 26
Learners explore working with complex data types in Apache Hive in this Skillsoft Aspire course, which assumes previous work with Hive tables using the Hive query language, and comfort using a command-line interface or Hive client to run queries. Learners begin this 12-video, hands-on course by working with Hive tables whose columns are of complex data types (arrays, maps, and structs). Watch demonstrations of set operations and transforming complex types into tabular form with explode operation. Then use lateral views to add more data to exploded outputs. Course labs use the Beeline client; the instructor’s Beeline terminal runs on the master node of a Hadoop cluster, provisioned on Google Cloud platform using its Dataproc service, and learner access is assumed to a Hadoop cluster and Beeline, on-premises or in the cloud. Finally, learners observe how to use views to aggregate contents of multiple columns. As the course concludes, you should be comfortable working with all types of data in Hive and performing analysis tasks on tables with both parameter types as well as complex data.

WHAT YOU WILL LEARN

  • load and access data in the form of arrays
    work with data in the form of key-value pairs - map data structures in Hive
    define and use structured data in the form of Hive struct types
    transform complex data types to a tabular format to facilitate analysis using the explode and posexplode functions
    combine the results of the explode function with other columns of a table to generate a lateral view
    flatten multi-dimensional data structures by chaining lateral views
  • use the UNION and UNION ALL operations on table data and distinguish between the two
    search for values in the results of a subquery using the IN and EXIST clauses
    create and load data into tables efficiently by including these operations in a single query
    define and work with views in Hive to simplify querying and control access to data
    perform queries and utilize views on complex data types available in Hive

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 15s
    UP NEXT
  • Playable
    2. 
    The Array Data Type in Hive
    9m 2s
  • Locked
    3. 
    The Map Data Type in Hive
    6m 18s
  • Locked
    4. 
    The Struct Type in Hive
    5m 57s
  • Locked
    5. 
    The explode and posexplode Functions in Hive
    7m 52s
  • Locked
    6. 
    Lateral Views in Hive
    6m 55s
  • Locked
    7. 
    Multiple Lateral Views in Hive
    6m 48s
  • Locked
    8. 
    Set Operations in Hive
    7m 9s
  • Locked
    9. 
    The IN and EXISTS clauses in Hive
    5m 24s
  • Locked
    10. 
    Creating and Populating Tables in Hive
    3m 9s
  • Locked
    11. 
    Views in Hive
    6m 14s
  • Locked
    12. 
    Exercise: Viewing and Querying Complex Data
    5m 50s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 10 Likes 10  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 104 Likes 104  
Likes 56 Likes 56  
Likes 9 Likes 9