question Re: Can we load csv from local directory to Hbase table? in Archives of Support Questions (Read Only)

Can we load csv from local directory to Hbase table?

iraz098 — Mon, 04 Jun 2018 15:26:03 GMT

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

Re: Can we load csv from local directory to Hbase table?

sandyy006 — Mon, 04 Jun 2018 15:31:01 GMT

@irfan aziz

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

Re: Can we load csv from local directory to Hbase table?

iraz098 — Mon, 04 Jun 2018 15:49:06 GMT

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

Re: Can we load csv from local directory to Hbase table?

sandyy006 — Mon, 04 Jun 2018 15:51:48 GMT

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