| Document Type
|
:
|
BL
|
| Record Number
|
:
|
856608
|
| Main Entry
|
:
|
Du, Dayong.
|
| Title & Author
|
:
|
Apache Hive Essentials : : Essential Techniques to Help You Process, and Get Unique Insights from, Big Data, 2nd Edition.
|
| Edition Statement
|
:
|
2nd ed.
|
| Publication Statement
|
:
|
Birmingham :: Packt Publishing Ltd,, 2018.
|
| Page. NO
|
:
|
1 online resource (203 pages)
|
| ISBN
|
:
|
1788995090
|
|
|
:
|
: 1789136512
|
|
|
:
|
: 9781788995092
|
|
|
:
|
: 9781789136517
|
| Contents
|
:
|
Cover; Title Page; Copyright and Credits; Dedication; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: Overview of Big Data and Hive; A short history; Introducing big data; The relational and NoSQL databases versus Hadoop; Batch, real-time, and stream processing; Overview of the Hadoop ecosystem; Hive overview; Summary; Chapter 2: Setting Up the Hive Environment; Installing Hive from Apache; Installing Hive from vendors; Using Hive in the cloud ; Using the Hive command; Using the Hive IDE; Summary; Chapter 3: Data Definition and Description; Understanding data types.
|
|
|
:
|
Bucket table designIndex design; Use skewed/temporary tables; Data optimization; File format; Compression; Storage optimization; Job optimization; Local mode; JVM reuse; Parallel execution; Join optimization; Common join; Map join; Bucket map join; Sort merge bucket (SMB) join; Sort merge bucket map (SMBM) join; Skew join; Job engine; Optimizer; Vectorization optimization; Cost-based optimization; Summary; Chapter 8: Extensibility Considerations; User-defined functions; UDF code template; UDAF code template; UDTF code template; Development and deployment; HPL/SQL; Streaming; SerDe; Summary.
|
|
|
:
|
Chapter 9: Security ConsiderationsAuthentication; Metastore authentication; Hiveserver2 authentication; Authorization; Legacy mode; Storage-based mode; SQL standard-based mode; Mask and encryption; The data-hashing function; The data-masking function; The data-encryption function; Other methods; Summary; Chapter 10: Working with Other Tools; The JDBC/ODBC connector; NoSQL; The Hue/Ambari Hive view; HCatalog; Oozie; Spark; Hivemall; Summary; Other Books You May Enjoy; Index.
|
|
|
:
|
Data type conversionsData Definition Language; Database; Tables; Table creation; Table description; Table cleaning; Table alteration; Partitions; Buckets; Views; Summary; Chapter 4: Data Correlation and Scope; Project data with SELECT; Filtering data with conditions; Linking data with JOIN; INNER JOIN; OUTER JOIN; Special joins; Combining data with UNION; Summary; Chapter 5: Data Manipulation; Data exchanging with LOAD; Data exchange with INSERT; Data exchange with [EX|IM]PORT; Data sorting; Functions; Function tips for collections; Function tips for date and string; Virtual column functions.
|
|
|
:
|
Transactions and locksTransactions; UPDATE statement; DELETE statement; MERGE statement; Locks; Summary; Chapter 6: Data Aggregation and Sampling; Basic aggregation ; Enhanced aggregation; Grouping sets; Rollup and Cube; Aggregation condition; Window functions; Window aggregate functions; Window sort functions; Window analytics functions; Window expression; Sampling; Random sampling; Bucket table sampling; Block sampling; Summary; Chapter 7: Performance Considerations; Performance utilities; EXPLAIN statement; ANALYZE statement; Logs; Design optimization; Partition table design.
|
| Abstract
|
:
|
Apache Hive helps you deal with data summarization, queries, and analysis for huge amounts of data. This book will give you a background in big data, and familiarize you with your Hive working environment. Next you will cover advanced topics like performance and security in Hive and how to work efficiently to find solutions to big data problems.
|
| Subject
|
:
|
Big data.
|
| Subject
|
:
|
Cloud computing.
|
| Subject
|
:
|
Databases-Design-Data processing.
|
| Subject
|
:
|
Electronic data processing-- Distributed processing.
|
| Subject
|
:
|
Big data.
|
| Subject
|
:
|
Cloud computing.
|
| Subject
|
:
|
Computers-- Data Processing.
|
| Subject
|
:
|
Computers-- Database Management-- Data Warehousing.
|
| Subject
|
:
|
Computers-- Database Management-- General.
|
| Subject
|
:
|
Data capture analysis.
|
| Subject
|
:
|
Data warehousing.
|
| Subject
|
:
|
Databases.
|
| Subject
|
:
|
Electronic data processing.
|
| Subject
|
:
|
Apache Hadoop.
|
|
|
:
|
Apache Hadoop.
|
| Dewey Classification
|
:
|
535.84
|
| LC Classification
|
:
|
QC100.D8 2018eb
|