Skip to content

Import CSV

Jump to bottom
Zhamri Che Ani edited this page Nov 29, 2023 · 4 revisions 
/Users/zhamri/Downloads/emp_data.csv

hadoop fs -mkdir /data

hadoop fs -copyFromLocal /Users/zhamri/Downloads/emp_data.csv /data

hadoop fs -ls /
hadoop fs -ls /data

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=’,’ -Dimporttsv.columns=’HBASE_ROW_KEY,cf:ename,cf:designation,cf:manager,cf:hire_date,cf:sal,cf:deptno’ emp_data /data/emp_data.csv

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv \
    -Dimporttsv.separator=',' \
    -Dimporttsv.columns='HBASE_ROW_KEY,cf:name,cf:designation,cf:manager,cf:hire_date,cf:sal,cf:deptno' \
    emp_data \
    /data/emp_data.csv

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=”,” -Dimporttsv.columns=HBASE_ROW_KEY,cf emp_data /data/emp_data.csv

STIA1123_Student_Info2.csv

hbase:010:0> create 'student', 'cf'

% hadoop fs -copyFromLocal /Users/zhamri/Downloads/STIA1123_Student_Info2.csv /data

% hadoop fs -ls /data

% hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=, -Dimporttsv.columns="HBASE_ROW_KEY,cf:NAME" student /data/STIA1123_Student_Info2.csv

Clone this wiki locally