January 2017
Intermediate to advanced
350 pages
7h 8m
English
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.
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.csvWDI_Country.csv (this is the file we will use)WDI_Series.csvWDI_CS_Notes.csvWDI_ST_Notes.csvWDI_Footnotes.csvWDI_Description.csvWe will be using this as data and nothing else; this is freely available on the aforementioned World Bank ...
Read now
Unlock full access