Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoops data warehouse infrastructure. Youll quickly learn how to use Hives SQL dialectHiveQLto summarize, query, and analyze large datasets stored in Hadoops distributed filesystem.This example-driven guide shows you how to set up and configure Hive in your environment, provides a detailed overview of Hadoop and MapReduce, and demonstrates how Hive works within the Hadoop ecosystem. Youll also find real-world case studies that describe how companies have used Hive to solve unique problems involving petabytes of data.Use Hive to create, alter, and drop databases, tables, views, functions, and indexes Customize data formats and storage options, from files to external databases Load and extract data from tablesand use queries, grouping, filtering, joining, and other conventional query methods Gain best practices for creating user defined functions (UDFs) Learn Hive patterns you should use and anti-patterns you should avoid Integrate Hive with other data processing programs Use storage handlers for NoSQL databases and other datastores Learn the pros and cons of running Hive on Amazons Elastic MapReduce
Cited By
- Lian J (2020). Implementation of computer network user behavior forensic analysis system based on speech data system log, International Journal of Speech Technology, 23:3, (559-567), Online publication date: 1-Sep-2020.
- Pilven M, Scherzinger S and d’Orazio L On Complex Value Relations in Hive Advances in Conceptual Modeling, (146-156)
- Mohammed A, Gadallah A, Hefny H and Hazman M (2018). Fuzzy based approach for discovering crops plantation knowledge from huge agro-climatic data respecting climate changes, Computing, 100:7, (689-713), Online publication date: 1-Jul-2018.
- Manogaran G and Lopez D (2017). Disease Surveillance System for Big Climate Data Processing and Dengue Transmission, International Journal of Ambient Computing and Intelligence, 8:2, (88-105), Online publication date: 1-Apr-2017.
- Santos M and Costa C Data Warehousing in Big Data Proceedings of the Ninth International C* Conference on Computer Science & Software Engineering, (51-60)
- Boubiche S, Boubiche D and Azzedine B Integrating Big data paradigm in WSNs Proceedings of the International Conference on Big Data and Advanced Wireless Technologies, (1-4)
- Barbierato E, Gribaudo M and Iacono M Modeling apache hive based applications in big data architectures Proceedings of the 7th International Conference on Performance Evaluation Methodologies and Tools, (30-38)