Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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.