Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • HBase High Performance Cookbook
  • Toc
  • feedback
HBase High Performance Cookbook

HBase High Performance Cookbook

By : Ruchir Choudhry
2.5 (2)
close
HBase High Performance Cookbook

HBase High Performance Cookbook

2.5 (2)
By: Ruchir Choudhry

Overview of this book

Apache HBase is a non-relational NoSQL database management system that runs on top of HDFS. It is an open source, disturbed, versioned, column-oriented store and is written in Java to provide random real-time access to big Data. We’ll start off by ensuring you have a solid understanding the basics of HBase, followed by giving you a thorough explanation of architecting a HBase cluster as per our project specifications. Next, we will explore the scalable structure of tables and we will be able to communicate with the HBase client. After this, we’ll show you the intricacies of MapReduce and the art of performance tuning with HBase. Following this, we’ll explain the concepts pertaining to scaling with HBase. Finally, you will get an understanding of how to integrate HBase with other tools such as ElasticSearch. By the end of this book, you will have learned enough to exploit HBase for boost system performance.
Table of Contents (13 chapters)
close
7
7. Large-Scale MapReduce
12
Index

Extracting data from Oracle

HBase doesn't allow direct interaction or a pipeline for data import from Oracle and MySQL to HBase. The basic concept remains the same: to first extract the data into flat / text files (ImportTsv format), transform the data into HFiles, and then load them into HBase by telling the region server where to find them.

Getting ready

Let's start with getting public data from the following URL:

http://databank.worldbank.org/data/download/WDI_csv.zip

This will have the following files:

  • WDI_Data.csv
  • WDI_Country.csv (this is the file we will use)
  • WDI_Series.csv
  • WDI_CS_Notes.csv
  • WDI_ST_Notes.csv
  • WDI_Footnotes.csv
  • WDI_Description.csv

We will be using this as data and nothing else; this is freely available on the aforementioned World Bank site.

We will then create a table in Oracle Schema on your SQL prompt:

The names of the column used have an exact match with WDI_Country.csv:

CREATE TABLE WDI_COUNTRY 

(
"COUNTRY_CODE" VARCHAR2(100 BYTE),

"SHORT_NAME&quot...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist download font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete