Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Can we load csv from local directory to Hbase table?

avatar
Rising Star

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

avatar
@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

avatar
@irfan aziz

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

avatar
Rising Star

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

avatar

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