Apache Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis. While initially developed by Facebook, Apache Hive is now used and developed by other companies such as Netflix. Hive is also included in Amazon Elastic MapReduce on Amazon Web Services.

1. Getting started with Apache Pig

   If, like me, you want to play around with data in a Hadoop cluster without having to write hundreds or thousands of lines of Java MapReduce code, you most likely will use either Hive (using the Hive Query Language HQL) or Pig. Hive is a SQL-like language which compiles to ...

2. BigData Driving Adoption of NoSQL in the Enterprise

   According to a recent Evans Data Study, “NoSQL is being rapidly accepted by corporate enterprise developers in North America with 56% reporting at least some use of the schemaless database and 63% citing plans to use in the next two years according to Evans Data’s recently released North American ...

3. Querying Hive with Toad for Cloud Databases

   I recently talked about using the Toad for Cloud Databases Eclipse plug-in to query an HBase database. After I finished up the video, I did some work loading a sample dataset from Retrosheet into my local Hive instance. This 7 minute tutorial shows you brand new functionality in the Toad ...

4. Five Reasons to Use NoSQL

   Five Reasons To Use NoSQL You’re not using a NoSQL database right now? I’m not all that surprised. Many IT shops are still evaluating moving from SQL Server 2000 to SQL Server 2005, much less these non-relational databases. A lot of people don’t even know what they ...

5. Why Use a NoSQL Database?

   NoSQL databases were born mostly from web-centric companies needing to solve problems out of the reach of modern relational databases. For those of us who are not running web-centric companies, are these NoSQL databases useful? I think they could be. Although the problems that motivated the NoSQL database movement may ...

6. Where did NoSQL Come From?

   Relational databases have reigned for so long that it is truly amazing to see a whole new class of databases emerging. These so-called NoSQL databases are decidedly non-relational in almost every regard: architecture, schema capabilities, APIs ­– even support for ACID transactions. (Carlo Strozzi first used the term NoSQL over 10 ...

7. Hive vs. Pig

   While I was looking at Hive and Pig for processing large amounts of data without the need to write MapReduce code I found that there is no easy way to compare them against each other without reading into both in greater detail. In this post I am trying to give ...