در این آموزش تصویری با Apache Hive آشنا می شوید. این دوره برای مبتدیان ارائه شده است. در این دوره نحوه ایجاد جداول ، دستکاری جداول با HiveQL ، نحوه ورود داده ها به جدول و استفاده از توابع را می آموزید. در ادامه نحوه استفاده از HiveQL ، کار با JDBC ، کار با Spark ، ایجاد دیدگاه ها و نحوه پارتیشن بندی را خواهید آموخت.

این دوره آموزشی محصول موسسه InfiniteSkills است.

سرفصل های دوره:

  • Apache Hive چیست؟
  • نحوه کار با Apache Hive
  • Hive CLI چیست؟
  • معرفی HUE
  • کار با JDBC
  • نحوه استفاده از جدول
  • نحوه بارگذاری داده ها
  • نحوه ایجاد جدول
  • نحوه بارگذاری اطلاعات
  • کار با ساختار Hive
  • نحوه دستکاری داده ها با HiveQL
  • کار با دستور SELECT
  • نحوه استفاده از HiveQL
  • نحوه ورود داده ها به Hive
  • نحوه پارتیشن بندی
  • کار با توابع
  • نحوه تبدیل داده ها
  • نحوه اجرای Hive
  • کار با Map Reduce
  • معرفی Spark
  • و…

عنوان دوره: InfiniteSkills Introduction to Apache Hive
مدت زمان: 2 ساعت و 15 دقیقه
نویسنده: Tom Hanlon


InfiniteSkills Introduction to Apache Hive

 1.75 hours
Tom Hanlon

In this project-based Introduction to Apache Hive video tutorial series, you'll quickly have relevant skills for real-world applications.
Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Introduction to Apache Hive training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Introduction to Apache Hive subjects because they're broken into simple, easy to follow tutorial videos
In this Introduction to Apache Hive training course, expert author Tom Hanlon will teach you how to create and query large datasets in Hadoop. This course is designed for the absolute beginner, meaning no experience with SQL or Hadoop is required.
You will start by learning how to connect to Hive, then jump into learning how to create tables and load data. From there, Tom will teach you how to manipulate tables with HiveQL, including how to insert data into a Hive table using HiveQL. This video tutorial also covers how to create views and partitions and transform data with custom scripts. Finally, you will learn about Hive execution engines, such as Map Reduce, Tez, and Spark.
Once you have completed this computer based training course, you will have learned how to create tables and load data in Hive, execute SQL queries, use user defined functions, and transform scripts.

01. Introduction
What Is Apache Hive And Who Uses It?
About The Author
What You Should Expect From This Video
02. Connecting To Hive
0201 Hive CLI
0202 Beeline
0203 HUE
0204 JDBC
03. Creating Tables And Loading Data
0301 Creating A Table
0302 Loading Data
0303 Hive Record Structure
0304 Hive Data Types
04. Manipulating Tables With HiveQL
0401 Select Statement - Part 1
0402 Select Statement - Part 2
0403 Inserting Data Into A Hive Table Using HiveQL
0404 Creating A Table Using HiveQL
05. Views And Partitions
0501 Creating And Using Views
0502 Creating And Using Partitions
06. Functions And Using Transform
0601 Built In Functions
0602 User Defined Functions
0603 Transforming Data With Custom Scripts
07. Hive Execution Engines
0701 Map Reduce
0702 Tez
0703 Spark
08. Conclusion
0801 Wrap Up