Free Downloads
Programming Hive

Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoop’s data warehouse infrastructure. You’ll quickly learn how to use Hive’s SQL dialect—HiveQL—to summarize, query, and analyze large datasets stored in Hadoop’s 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. You’ll 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 indexesCustomize data formats and storage options, from files to external databasesLoad and extract data from tables—and use queries, grouping, filtering, joining, and other conventional query methodsGain best practices for creating user defined functions (UDFs)Learn Hive patterns you should use and anti-patterns you should avoidIntegrate Hive with other data processing programsUse storage handlers for NoSQL databases and other datastoresLearn the pros and cons of running Hive on ’s Elastic MapReduce

Paperback: 350 pages

Publisher: O'Reilly Media; 1 edition (October 6, 2012)

Language: English

ISBN-10: 1449319335

ISBN-13: 978-1449319335

Product Dimensions: 7 x 0.8 x 9.2 inches

Shipping Weight: 1.2 pounds (View shipping rates and policies)

Average Customer Review: 4.5 out of 5 stars  See all reviews (14 customer reviews)

Best Sellers Rank: #298,066 in Books (See Top 100 in Books) #82 in Books > Computers & Technology > Databases & Big Data > Data Warehousing #143 in Books > Computers & Technology > Databases & Big Data > SQL #148 in Books > Computers & Technology > Databases & Big Data > Data Modeling & Design

Well written, good book. However how fast Hive/hadoop is moving, I think this book will be out of data (already is in parts) soon. I'm assuming they'll come out with updated v2 of the book in the future.

I had joined Nextag a few months before this book got released and my solo-artist project was to convert all MySQL aggregations to Hadoop. I was thinking MR Java, HBase - and then I started reading this book. Start to end it took me less than a week and I decided that I want to give Hive a shot. It was possibly Hive 0.8 in late 2012 if my memory serves me right. I joined the Hive user group and also had the good fortune of communicating with two of the authors Capriolo and Wampler ad seeking clarifications. I don't want to go into the details of how well written this book is. Thye developers who read this review will get it when that reading this book and actively participating in the Hive community helped me a great deal to execute a project all the way from start to production - all by myself...If the authors want to publish a V2 , I would love to write a case study :-)

It's a great resource, and remains on my desk; however it already feels outdated (bought in October 2012.) There are many commands and functions that aren't in this book for whatever reason.Still, a great start - the floodgates should be open to Hive reference material!

Good book - I used it to study for a presentation I needed to give our group at work. It's needing an update with Impala/Stinger/Presto now available to improve performance.

Coming from the days when the only Hive documentation was the Apache.org wiki, this book is a godsend.Very readable by mere mortals, it gives clear, concise explanations of how Hive works as well as tips and trick for performance.People new to Hive will get a grasp of the power of Hive. Old hands will probably pick up a few tricks and nuances.And did I mention it's quite readable--not like a lot of tech books. Thats very strong praise right there.

This is by far the most complete and precise documentation about Hive.If you have enough knowledge of Java and are familiar with Hive code, this book helps you a lot to manipulate Hive code.Though I expected more programming lessons and implementation details on Hive from the title.

this give good information with some good example.good for basic.but it's little old.example might not work. but should give good start for starter

Programming #8:C Programming Success in a Day & Android Programming In a Day! (C Programming, C++programming, C++ programming language, Android , Android Programming, Android Games) Programming #57: C++ Programming Professional Made Easy & Android Programming in a Day (C++ Programming, C++ Language, C++for beginners, C++, Programming ... Programming, Android, C, C Programming) Programming #45: Python Programming Professional Made Easy & Android Programming In a Day! (Python Programming, Python Language, Python for beginners, ... Programming Languages, Android Programming) Programming: Computer Programming for Beginners: Learn the Basics of Java, SQL & C++ - 3. Edition (Coding, C Programming, Java Programming, SQL Programming, JavaScript, Python, PHP) Raspberry Pi 2: Raspberry Pi 2 Programming Made Easy (Raspberry Pi, Android Programming, Programming, Linux, Unix, C Programming, C+ Programming) Android: Programming in a Day! The Power Guide for Beginners In Android App Programming (Android, Android Programming, App Development, Android App Development, ... App Programming, Rails, Ruby Programming) DOS: Programming Success in a Day: Beginners guide to fast, easy and efficient learning of DOS programming (DOS, ADA, Programming, DOS Programming, ADA ... LINUX, RPG, ADA Programming, Android, JAVA) ASP.NET: Programming success in a day: Beginners guide to fast, easy and efficient learning of ASP.NET programming (ASP.NET, ASP.NET Programming, ASP.NET ... ADA, Web Programming, Programming) C#: Programming Success in a Day: Beginners guide to fast, easy and efficient learning of C# programming (C#, C# Programming, C++ Programming, C++, C, C Programming, C# Language, C# Guide, C# Coding) FORTRAN Programming success in a day:Beginners guide to fast, easy and efficient learning of FORTRAN programming (Fortran, Css, C++, C, C programming, ... Programming, MYSQL, SQL Programming) Prolog Programming; Success in a Day: Beginners Guide to Fast, Easy and Efficient Learning of Prolog Programming (Prolog, Prolog Programming, Prolog Logic, ... Programming, Programming Code, Java) R Programming: Learn R Programming In A DAY! - The Ultimate Crash Course to Learning the Basics of R Programming Language In No Time (R, R Programming, ... Course, R Programming Development Book 1) Parallel Programming: Success in a Day: Beginners' Guide to Fast, Easy, and Efficient Learning of Parallel Programming (Parallel Programming, Programming, ... C++ Programming, Multiprocessor, MPI) Programming Hive MYSQL Programming Professional Made Easy 2nd Edition: Expert MYSQL Programming Language Success in a Day for any Computer User! (MYSQL, Android programming, ... JavaScript, Programming, Computer Software) Programming Raspberry Pi 3: Getting Started With Python (Programming Raspberry Pi 3, Raspberry Pi 3 User Guide, Python Programming, Raspberry Pi 3 with Python Programming) VBScript: Programming Success in a Day: Beginner's Guide to Fast, Easy and Efficient Learning of VBScript Programming (VBScript, ADA, ASP.NET, C#, ADA ... ASP.NET Programming, Programming, C++, C) Apps: Mobile App Trends in 2015 (iOS, Xcode Programming, App Development, iOS App Development, App Programming, Swift, Without Coding) ((Android, Android ... App Programming, Rails, Ruby Programming)) XML Programming Success in a Day: Beginner's Guide to Fast, Easy, and Efficient Learning of XML Programming (XML, XML Programming, Programming, XML Guide, ... XSL, DTD's, Schemas, HTML5, JavaScript) Beeswax Alchemy: How to Make Your Own Soap, Candles, Balms, Creams, and Salves from the Hive