Viewing & Querying Complex Data with Hive

Apache Hive 2.3.2    |    Beginner
  • 12 videos | 1h 12m 54s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 12 users Rating 4.5 of 12 users (12)
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

  • 2m 15s
  • 9m 2s
    In this video, you will load and access data in arrays. FREE ACCESS
  • Locked
    3.  The Map Data Type in Hive
    6m 18s
    Learn how to work with data in the form of key-value pairs - map data structures in Hive. FREE ACCESS
  • Locked
    4.  The Struct Type in Hive
    5m 57s
    Find out how to define and use structured data in the form of Hive struct types. FREE ACCESS
  • Locked
    5.  The explode and posexplode Functions in Hive
    7m 52s
    In this video, you will transform complex data types to a tabular format to facilitate analysis using the explode and posexplode functions. FREE ACCESS
  • Locked
    6.  Lateral Views in Hive
    6m 55s
    In this video, find out how to combine the results of the explode function with other columns of a table to generate a lateral view. FREE ACCESS
  • Locked
    7.  Multiple Lateral Views in Hive
    6m 48s
    In this video, learn how to flatten multi-dimensional data structures by using lateral views. FREE ACCESS
  • Locked
    8.  Set Operations in Hive
    7m 9s
    During this video, you will learn how to use the UNION and UNION ALL operations on table data and distinguish between the two. FREE ACCESS
  • Locked
    9.  The IN and EXISTS clauses in Hive
    5m 24s
    During this video, you will learn how to search for values in the results of a subquery using the IN and EXIST clauses. FREE ACCESS
  • Locked
    10.  Creating and Populating Tables in Hive
    3m 9s
    To find out how to create and load data into tables efficiently, include these operations in a single query. FREE ACCESS
  • Locked
    11.  Views in Hive
    6m 14s
    In this video, you will define and work with views in Hive to simplify querying and control access to data. FREE ACCESS
  • Locked
    12.  Exercise: Viewing and Querying Complex Data
    5m 50s
    During this video, you will learn how to perform queries and utilize views on complex data types available in Hive. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Setting up the Data Infrastructure in an Organization
Rating 4.4 of 39 users Rating 4.4 of 39 users (39)
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course Getting Started with Snowflake: Queries, Dashboards, & Tables
Rating 4.7 of 149 users Rating 4.7 of 149 users (149)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Overview & Syntax Basics
Rating 4.0 of 54 users Rating 4.0 of 54 users (54)
Course Using Hive to Optimize Query Executions with Partitioning
Rating 4.8 of 14 users Rating 4.8 of 14 users (14)
Course Microsoft Analytics Platform System & Hive
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)