7. Hadoop and SQL | Learning Hadoop 2

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Hadoop 2

By : GABRIELE MODENA

3.8 (4)

Learning Hadoop 2

3.8 (4)

By: GABRIELE MODENA

Overview of this book

If you are a system or application developer interested in learning how to solve practical problems using the Hadoop framework, then this book is ideal for you. You are expected to be familiar with the Unix/Linux command-line interface and have some experience with the Java programming language. Familiarity with Hadoop would be a plus.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Introduction

1. Introduction

A note on versioning

The background of Hadoop

Components of Hadoop

Hadoop 2 – what's the big deal?

Distributions of Apache Hadoop

A dual approach

AWS – infrastructure on demand from Amazon

Getting started

Running the examples

Data processing with Hadoop

Summary

2. Storage

2. Storage

The inner workings of HDFS

Command-line access to the HDFS filesystem

Protecting the filesystem metadata

Apache ZooKeeper – a different type of filesystem

Automatic NameNode failover

HDFS snapshots

Hadoop filesystems

Managing and serializing data

Storing data

Summary

3. Processing – MapReduce and Beyond

3. Processing – MapReduce and Beyond

MapReduce

Java API to MapReduce

Writing MapReduce programs

Walking through a run of a MapReduce job

YARN

YARN in the real world – Computation beyond MapReduce

Summary

4. Real-time Computation with Samza

4. Real-time Computation with Samza

Stream processing with Samza

Summary

5. Iterative Computation with Spark

5. Iterative Computation with Spark

Apache Spark

The Spark ecosystem

Processing data with Apache Spark

Comparing Samza and Spark Streaming

Summary

6. Data Analysis with Apache Pig

6. Data Analysis with Apache Pig

An overview of Pig

Getting started

Running Pig

Fundamentals of Apache Pig

Programming Pig

Extending Pig (UDFs)

Analyzing the Twitter stream

Summary

7. Hadoop and SQL

7. Hadoop and SQL

Why SQL on Hadoop

Prerequisites

Hive architecture

Hive and Amazon Web Services

Extending HiveQL

Programmatic interfaces

Stinger initiative

Impala

Summary

8. Data Lifecycle Management

8. Data Lifecycle Management

What data lifecycle management is

Building a tweet analysis capability

Challenges of external data

Collecting additional data

Pulling it all together

Summary

9. Making Development Easier

9. Making Development Easier

Choosing a framework

Hadoop streaming

Kite Data

Apache Crunch

Summary

10. Running a Hadoop Cluster

10. Running a Hadoop Cluster

I'm a developer – I don't care about operations!

Cloudera Manager

Ambari – the open source alternative

Operations in the Hadoop 2 world

Sharing resources

Building a physical cluster

Building a cluster on EMR

Cluster tuning

Security

Monitoring

Troubleshooting

Summary

11. Where to Go Next

11. Where to Go Next

Alternative distributions

Other computational frameworks

Other interesting projects

Other programming abstractions

AWS resources

Sources of information

Summary

Index

Index

Programmatic interfaces

In addition to the hive and beeline command-line tools, it is possible to submit HiveQL queries to the system via the JDBC and Thrift programmatic interfaces. Support for ODBC was bundled in older versions of Hive, but as of Hive 0.12, it needs to be built from scratch. More information on this process can be found at https://cwiki.apache.org/confluence/display/Hive/HiveODBC.

JDBC

A Hive client written using JDBC APIs looks exactly the same as a client program written for other database systems (for example MySQL). The following is a sample Hive client program using JDBC APIs. The source code for this example can be found at https://github.com/learninghadoop2/book-examples/blob/master/ch7/clients/com/learninghadoop2/hive/client/HiveJdbcClient.java.

public class HiveJdbcClient {
     private static String driverName = " org.apache.hive.jdbc.HiveDriver";
     
     // connection string
     public static String URL = "jdbc:hive2://localhost:10000";

     // Show all tables...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Hadoop 2

Search

Your notes and bookmarks