Skip to content

Import CSV

Jump to bottom
Zhamri Che Ani edited this page Nov 28, 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

Clone this wiki locally