Can we load csv from local directory to Hbase table?

[#1]

I am trying to load the hbase table from a data file on my local path but it fails with below error.

hbase(main):010:0> hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator="," -Dimporttsv.columns="HBASE_ROW_KEY,events:driverId,events:driverName,events:eventTime,events:eventType,events:latitudeColumn,events:longitudeColumn,events:routeId,events:routeName,events:truckId" irfan_ns:driver_dangerous_event file:///home/aziz/driver
SyntaxError: (hbase):10: syntax error, unexpected tIDENTIFIER

[#2 · Accepted solution]

@irfan aziz

Importtsv is not a hbase shell command, Please exit hbase shell and execute the same command.

[#3]

Thank you Sandeep. That was so quick ! Saved my day.

[#4]

@irfan aziz Glad that it helped! Please click on "Accept" to mark this thread as closed.