|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learning-apache-hive/
课程评论：没有评论
课程名称：学习Apache Hadoop生态系统 - Hive 课程概述： 本课程创建于四年前，根据需求将添加新教程。课程开始时将讲解Hive架构的必要性及其不同的配置参数。您将学习Hive的不同方面，以及它如何作为Hadoop上的数据仓库平台。本课程涵盖Hive的基本知识，包括Hadoop的SQL（HQL）。我们将学习Hive的安装与配置过程，探索Hive的组件和架构，了解它如何在HDFS上以表格结构存储数据。 课程内容包括： - 理解Hive的架构、安装和配置； - 安装并配置Hive Server2，并将PostgreSQL数据库替换为MySQL； - 安装MySQL并配置为Hive Metastore； - 创建数据库、理解数据类型、创建外部表、内部表和分区表； - 数据的分桶加载，包括从本地文件系统及分布式文件系统（HDFS）加载数据； - 设置动态分区、创建视图以及管理索引，了解不同层级如何在Hive中协同工作； - 讨论在实际项目中实施的不同角色、项目设置和权限管理、审计及故障排除。 此外，本课程提供示例数据和查询供学员实践，课程中还有多个问题可供测试学习者的理解。请尽量回答所有问题。 更多详细信息，请订阅我的YouTube频道“Hadooparch”。
*** This is Course was Created 4 years back. New tutorials will be added based on requirements.*** This tutorial starts with understanding need for hive Architecture and different configuration parameters in Hive. During this course you will learn different aspects of Hive and how it fits as datawarehousing patform on Hadoop. Please subscribe to my Youtube Channel "Hadooparch" for more details. This Course covers Hive, the SQL of Hadoop.(HQL) We will learn why and How Hive is installed and configured on Hadoop. We will cover the components and architecture of Hive to see how it stores data in table like structures over HDFS data. Understabd architecture, installation and configuration of Hive. We will install and configure Hive server2 and replace postgresql database with mysql. we will also learn how to install mysql and configure it as Hive Metastore This Course is full of Hive demonstrations. We'll cover how to create Databases, understand data types, create external, internal, and partitioned hive tables, bucketing load data from the local filesystem as well as the distributed filesystem (HDFS), setup dynamic partitioning, create views, and manage indexes and how different layers work together on Hive. We will go through different roles in implementing in Real time projects, how projects are set up and permissions, Auditing, Troubleshooting. Finally I will give sample data and queries to work and replicate what has been taught in Videos. This Course has multiple questions to test your understanding. Kindly attempt all of them.
