https://community.cloudera.com/t5/Support-Questions/importing-csv-file-in-hbase/m-p/166226#M128578 <P>I solved this problem using the following method , but I do want to know why would one want to use the SERDE method and not this one?</P><PRE>[hbase@hadoop1 ~]$ more a.csv 5842,50,30,4,240,340 5843,52,32,5,250,360 5844,56,31,2,248,333 [hbase@hadoop1 ~]$ create table test3(Id int, lowT string, highT string,vib int, lowP string,highP string) ROW FORMAT DELIMITED FIELDS TERMINATED BY "," STORED AS TEXTFILE TBLPROPERTIES("skip.header.line.count"="1"); load data inpath '/user/hbase/a.csv' OVERWRITE INTO TABLE test3; Loading data to table default.test3 Table default.test3 stats: [numFiles=1, numRows=0, totalSize=63, rawDataSize=0] OK Time taken: 0.668 seconds </PRE> Tue, 21 Mar 2017 21:32:08 GMT aliyesami 2017-03-21T21:32:08Z