SQL on Hadoop - Analyzing Big Data with Hive [2013, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL on Hadoop - Analyzing Big Data with Hive

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com
Автор: Ahmad Alkilani
Продолжительность: 4h 16m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: This course will teach you the Hive query language and how to apply it to solve common Big Data problems. This includes an introduction to distributed computing, Hadoop, and MapReduce fundamentals and the latest features released with Hive 0.11

Этот курс научит вас языку Hive запрос и как его применять для решения общих Большие проблемы данных. Это включает в себя введение в распределенные вычисления, Hadoop и MapReduce основы и новейшие функции выпущен с Hive 0,11
[spoiler="Содержание"]
│ sql-hadoop-analyzing-big-data-hive.zip
│
├───01. Introduction to Hadoop
│ 01. Introduction.wmv
│ 02. Motivation for Hadoop.wmv
│ 03. Distributed Computing Challenges.wmv
│ 04. Hadoop File System (HDFS).wmv
│ 05. MapReduce.wmv
│ 06. Word Count Example.wmv
│ 07. Demo Basic Hadoop Commands and Environment Setup.wmv
│ 08. Summary.wmv
│
├───02. Introduction to Hive
│ 01. Introduction.wmv
│ 02. O£Hive Motivation.wmv
│ 03. Hive Architecture.wmv
│ 04. Hive Principles - Schema on Read.wmv
│ 05. Hive Principles - The Hive Warehouse.wmv
│ 06. Hive Query Language Basics - SELECT and Sub Queries.wmv
│ 07. Creating Databases and Tables with HiveQL.wmv
│ 08. Demo Working with Hive Tables and Loading Data into Warehouse.wmv
│ 09. Loading Data - Hive Managed and External Tables.wmv
│ 10. Demo External Tables and Create Table Alternatives.wmv
│ 11. Summary.wmv
│
├───03. Hive Query Language
│ 01. Introduction.wmv
│ 02. Data Types.wmv
│ 03. Type Conversions.wmv
│ 04. Managed Partitioned Tables.wmv
│ 05. External Partitioned Tables.wmv
│ 06. Demo Table Partitioning.wmv
│ 07. Multi Inserts and Dynamic Partition Inserts.wmv
│ 08. Demo Loading Data Use Case.wmv
│ 09. Data Retrieval - Group By and Functions.wmv
│ 10. Sorting and Controlling Data Flow.wmv
│ 11. The CLI and Variable Substitution.wmv
│ 12. Summary.wmv
│
├───04. Advanced HiveQL
│ 01. Introduction.wmv
│ 02. Bucketing.wmv
│ 03. Bucket and Block Sampling.wmv
│ 04. Joins.wmv
│ 05. Joins in Depth and Join Optimizations.wmv
│ 06. Map-side Joins for Bucketed Tables.wmv
│ 07. Distributed Cache.wmv
│ 08. UDTFs, Explode and Lateral View.wmv
│ 09. Demo Extending Hive - Creating Your own UDF.wmv
│ 10. Demo Extending Hive - Compiling and Testing Custom UDF.wmv
│ 11. Extending Hive - Custom UDF Recap.wmv
│ 12. Demo Hive Initialization File.wmv
│ 13. Accessing The Distributed Cache.wmv
│ 14. Hadoop Streaming and Transform().wmv
│ 15. Windowing and Analytics Functions.wmv
│ 16. Demo Putting it All Together Using Transform.wmv
│ 17. Demo Analytics Functions.wmv
│ 18. Demo Ranking Functions.wmv
│ 19. Summary.wmv
│
└───05. Storage and The Eco-System
01. Create Table Statement - File Formats and SerDes.wmv
02. HCatalog.wmv
03. Sqoop.wmv
04. DistCP.wmv
05. Hadoop Eco-System Projects.wmv
06. References and Resources.wmv
07. Summary.wmv
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
[spoiler="audio\video"]
General
Complete name : C:\01. Introduction to Hadoop\01. Introduction.wmv
Format : Windows Media
File size : 2.33 MiB
Duration : 1mn 47s
Overall bit rate mode : Variable
Overall bit rate : 182 Kbps
Maximum Overall bit rate : 212 Kbps
Encoded date : UTC 2013-10-08 16:15:59.630

Video
ID : 2
Format : VC-1
Format profile : MP@HL
Codec ID : WMV3
Codec ID/Info : Windows Media Video 9
Codec ID/Hint : WMV3
Description of the codec : Windows Media Video 9
Duration : 1mn 47s
Bit rate mode : Variable
Bit rate : 18.9 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Compression mode : Lossy
Bits/(Pixel*Frame) : 0.002
Stream size : 249 KiB (10%)
Language : English (US)

Audio
ID : 1
Format : WMA
Format version : Version 2
Codec ID : 161
Codec ID/Info : Windows Media Audio
Description of the codec : Windows Media Audio 9.2 - 128 kbps, 44 kHz, stereo (A/V) 1-pass CBR
Duration : 1mn 47s
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Sampling rate : 44.1 KHz
Bit depth : 16 bits
Stream size : 1.65 MiB (70%)
Language : English (US)
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]