Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Can we load csv from local directory to Hbase table?

Solved Go to solution
Highlighted

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

Accepted Solutions

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

@irfan aziz

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

3 REPLIES 3

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

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

Explorer

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

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here