|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/from-0-to-1-hive/
课程评论：没有评论
课程名称：从零到一：使用Hive处理大数据 **课程概述：** 本课程是一门端到端的实践指南，旨在帮助您掌握使用Hive处理大数据的技能。Hive拥有熟悉的用户界面（类似SQL），能够让您利用Hadoop和分布式计算的能力进行分析处理。 **先修知识：** * **SQL:** 课程包含SQL入门部分，如果您不熟悉SQL，建议先学习。 * **Java (可选):** 如需学习自定义函数部分，需要Java知识。 **讲师团队：** 课程由一支经验丰富的团队教授，其中包括两名斯坦福毕业生、前谷歌工程师，以及两名前Flipkart首席分析师，他们拥有数十年的大规模数据处理实战经验。 **课程亮点：** * **SQL新手友好:** 课程提供深入的SQL基础知识 primer，填补SQL与Hive之间的知识鸿沟。 * **端到端覆盖:** 无论您是需要处理数据的分析师，还是需要构建自定义功能或优化性能的工程师，本课程都将提供所需的一切。 * **实践导向:** 所有内容均通过真实场景、工作查询和代码进行讲解。 **课程内容：** * **分析处理:** * Join, Subqueries, Views * Table Generating Functions, Explode, Lateral View * Windowing 函数 * 以及更多…… * **Hive性能调优:** * Partitioning（分区） * Bucketing（分桶） * Join Optimizations（Join优化） * Map Side Joins * Indexes（索引） * **自定义函数开发:** * 使用Java编写自定义UDF (User Defined Functions), UDAF (User Defined Aggregate Functions), GenericUDF, GenericUDTF * 使用Python编写自定义函数 * MapReduce 的实现：SELECT, GROUP BY, Join **适合人群：** * 希望学习大数据处理的分析师。 * 需要构建自定义功能或优化性能的工程师。 * 对Hive感兴趣，希望深入了解其工作原理和实际应用的学习者。
Prerequisites: Hive requires knowledge of SQL. The course includes and SQL primer at the end. Please do that first if you don't know SQL. You'll need to know Java if you want to follow the sections on custom functions. Taught by a 4 person team including 2 Stanford-educated, ex-Googlers and 2 ex-Flipkart Lead Analysts. This team has decades of practical experience in working with large-scale data. Hive is like a new friend with an old face (SQL). This course is an end-to-end, practical guide to using Hive for Big Data processing. Let's parse that A new friend with an old face: Hive helps you leverage the power of Distributed computing and Hadoop for Analytical processing. It's interface is like an old friend: the very SQL like HiveQL. This course will fill in all the gaps between SQL and what you need to use Hive. End-to-End: The course is an end-to-end guide for using Hive: whether you are analyst who wants to process data or an Engineer who needs to build custom functionality or optimize performance - everything you'll need is right here. New to SQL? No need to look elsewhere. The course has a primer on all the basic SQL constructs,. Practical: Everything is taught using real-life examples, working queries and code. What's Covered: Analytical Processing: Joins, Subqueries, Views, Table Generating Functions, Explode, Lateral View, Windowing and more Tuning Hive for better functionality: Partitioning, Bucketing, Join Optimizations, Map Side Joins, Indexes, Writing custom User Defined functions in Java. UDF, UDAF, GenericUDF, GenericUDTF, Custom functions in Python, Implementation of MapReduce for Select, Group by and Join For SQL Newbies: SQL In Great Depth
