Support Questions
Find answers, ask questions, and share your expertise

Can we load csv from local directory to Hbase table?

Explorer

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

1 ACCEPTED SOLUTION

@irfan aziz

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

View solution in original post

3 REPLIES 3

@irfan aziz

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

Explorer

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

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

; ;