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.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 tables—and 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
Amazon’s Elastic MapReduce This example-driven guide shows you
how to set up and configure Hive in your environment, provides a
detailed overview of Hado